Conditional Format help [Closed]

Report
Posts
1
Registration date
Tuesday July 11, 2017
Status
Member
Last seen
July 11, 2017
-
Posts
1890
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
March 3, 2021
-
I have an excel spreadsheet set up with 4 columns:
Start Date/30 days after Start Date/60 days after Start Date/90 days after Start Date

What I would like to achieve is that when the Start Date has exceeded 30, 60 or 90 days, those certain columns would turn a different color.

So for example, in my first row. If my start date is 3/16/17, all three of the 30, 60 and 90 days should turn red because today is after all three of those dates.

However if my start date was 5/26/17 the only date that should turn red when I log in today, would be the 30 days since the 60 and 90 date is in the future.

1 reply

Posts
1890
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
March 3, 2021
142
jamie_ut, Good afternoon.

Suppose:
A2 --> Start date
B2 --> Date 30 days after Start Date
C2 --> Date 60 days after Start Date
D2 --> Date 90 days after Start Date

Try to use:

a) Select B2:D2

b) Conditional Format
Using formula

--> =TODAY()>=B2
--> Format: Fill color RED
OK

Please, tell us if it worked as you desired.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!