Conditional Format help

Closed
jamie_ut Posts 1 Registration date Tuesday July 11, 2017 Status Member Last seen July 11, 2017 - Jul 11, 2017 at 10:53 AM
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 - Jul 11, 2017 at 11:31 AM
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

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Jul 11, 2017 at 11:31 AM
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.
0