Results 1 to 8 of 8

Moving of grey column following today date in timing plan

Threaded View

Topa2 Moving of grey column... 01-13-2017, 08:55 AM
sandy666 Re: Moving of grey column... 01-13-2017, 09:25 AM
Topa2 Re: Moving of grey column... 01-13-2017, 10:58 AM
Topa2 Re: Moving of grey column... 01-13-2017, 11:04 AM
Pete_UK Re: Moving of grey column... 01-13-2017, 09:25 AM
Topa2 Re: Moving of grey column... 01-13-2017, 11:07 AM
sandy666 Re: Moving of grey column... 01-13-2017, 11:15 AM
Pete_UK Re: Moving of grey column... 01-13-2017, 11:55 AM
  1. #1
    Registered User
    Join Date
    10-16-2014
    Location
    Republic Czech
    MS-Off Ver
    Czech
    Posts
    32

    Moving of grey column following today date in timing plan

    Hi,

    I have a function which is checking start date and end date for activity and following this two dates is coloring the cells in the timing plan (have a look for attached file).
    Anyway I would like to modify the function (if possible) and everyday to change column following today date. As you can see I have colored the column O by greay color because today is 13.01/.017. At Monday will be 16.01.2017 so I would like that on Monday the grey column will on column R.

    The function used in english is =IF(AND(K$5>=$I7, K$5<=$J7),$H7,"")

    Thank you
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to fill an array with values in column C based on Column D date value of Today
    By jrtraylor in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-10-2016, 07:44 PM
  2. Moving data daily to a different column with the today function possible?
    By darthorious in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-09-2015, 03:51 PM
  3. [SOLVED] Unlock only if column date is equal to today's date +/- 2 days
    By Cobelatte in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-22-2015, 01:30 PM
  4. [SOLVED] Single column countif with moving range based on today's date
    By JonesyCC in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-16-2013, 02:45 PM
  5. Replies: 10
    Last Post: 05-11-2012, 02:14 AM
  6. Replies: 15
    Last Post: 02-06-2012, 04:25 AM
  7. Replies: 6
    Last Post: 08-08-2011, 08:32 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1