conditional formating

  • Thread starter Thread starter Tracy
  • Start date Start date
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
 
Select the column...........assume column A

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

Format to desired color and OK


Gord Dibben MS Excel MVP
 
Back
Top