Conditional highlighting from current date

O

oxag

Hi,

I would like to create a spreadsheet with dates as cell values and ge
Excel 97 to highlight those cells that contain the current dat
whenever I open that sheet.

Is this possible with Excel 97?

If not, which version of Excel (if any) would allow this?

If yes, how do I go about it and what date format should I use?

Thanks for any help
 
B

Biff

Hi oxag!

Select the cells with the dates.
Goto Format>Conditional Formatting.
In the first dropdown list, select: Formula is
In the text box that opens enter this formula:

=A1=TODAY() (adjust the cell ref to suit)

Then select the formats that you want and OK out.

Biff
 
T

theillknight

Hi,

I don't know about Excel 97, but with Excel 2002 you can go to th
'dates' cells, then to Format - Conditional Formatting. Choose 'Cel
Value Is' 'equal to' '=today()'
 
Top