Thread
:
Conditional formatting on Date
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons
external usenet poster
Posts: 1,696
Conditional formatting on Date
in Conditional formatting, formula is
=cell<=now()-365
"Rick1" wrote:
I have a cell with a training date. I would like to format the cell to
change color when actual date exceeds training date by one year.
Reply With Quote
Sean Timmons
View Public Profile
Find all posts by Sean Timmons