Conditional Formatting on Dates

[Wookieuk]

Hi

Im looking for some help with the following.

I have created a spreadsheet and one of the columns I hvae titled planned date, and a I have used conditional fomatting to show orange when I am less than one month away from the date, and to show red when I am less than a week from the date.

My next column is actual date. If the date I enter is before the planned date, I want the cell in the planned column to go green, even if it is already showing orange or red.

I hope this makes sense.

Thanks
Les

[NBVC]

Set this new condition as the first condition and check the stop if True checkbox.

you can use Format only cells that contain

The Cell Value >> Is greater than >> =B2

where B2 is top most cell in the Actual date column corresponding to top most selected cell in the planned column

[Wookieuk]

Thanks NBVC

I will try this at work to-morrow, and let you know

Les