conditional formating
Select the column...........assume column A
FormatCFFormula is: =$A1<TODAY()
Format to desired color and OK
Gord Dibben MS Excel MVP
On Thu, 27 Nov 2008 21:28:45 -0000, "Tracy"
wrote:
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
|