Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: highlight column based on date

  1. #1
    Board Regular
    Join Date
    Sep 2013
    Posts
    1,053
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default highlight column based on date

    Hi, I have a gantt chart created in excel.

    In Row 14 I have the date at weekly intervals. Starting at column K.
    In the row beneath (15) I have a week number.

    I have a range of rows underneath row 14. I would like to use conditional formatting to highlight the column containing the current week number in row 15.

    I have tried all kinds but cannot resolve, and help would be appreciated.

    Thanks,
    Last edited by nparsons75; Jun 19th, 2017 at 05:55 AM.

  2. #2
    Board Regular
    Join Date
    Oct 2015
    Location
    Dorset, England
    Posts
    460
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: highlight column based on date

    Use the formula option of conditional formatting. The formula for column k is:
    =and(now() >= K$14,now() < L$14)

  3. #3
    Board Regular
    Join Date
    Sep 2013
    Posts
    1,053
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: highlight column based on date

    Thank you Trevor, thanks for your time and help.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com