Conditional Formatting

[AjZeitz]

I have a product that I want a date range, such as 7-16 Jun 05, to turn red when due in 7 days, turn green when it is due in 3 days and until after the date range is over, and turn black when it is in the past.

Thanks.

Amanda

 

[Richard Schollar]

Hi Amanda

In which cell(s) is your date range?

Regards

Richard