Conditional formatting using a date range

[Fireguy5309]

Hi everyone, I am hoping to get a little help. I am trying to conditionally fomat a cell range to change colors if and when the system date exceeds the date in the cell. I can get it to change but can not get it to clear once I change the date in the cell. The cell is formatted to auto calculate a date by when training is due. Any help anyone can give me on this is greatly appreciated.

Fireguy

 

[Norie]

What have you tried for the conditional formatting?

You should just be able to select the range, goto conditional formatting, select Cell Value is , select less than and enter =TODAY().

 

[Fireguy5309]

Norie you are a god, thank you so much. Still a beginner excel user here again thank you so very much

Fireguy