Results 1 to 3 of 3

highlight column based on date

This is a discussion on highlight column based on date within the Excel Questions forums, part of the Question Forums category; Hi, I have a gantt chart created in excel. In Row 14 I have the date at weekly intervals. Starting ...

  1. #1
    Board Regular
    Join Date
    Sep 2013
    Posts
    967

    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
    426

    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
    967

    Default Re: highlight column based on date

    Thank you Trevor, thanks for your time and help.

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