conditional formating

T

Tracy

I have a spreadsheet with a column of dates from the past to the future. How
can I format the cells so that the dates previous to today have a colour in
the cells?

Thanks, Tracy
 
G

Gord Dibben

Select the column...........assume column A

Format>CF>Formula is: =$A1<TODAY()

Format to desired color and OK


Gord Dibben MS Excel MVP
 
Top