Conditional highlighting from current date

  • Thread starter Thread starter oxag
  • Start date Start 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
 
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
 
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()'
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional formatting date and blank cell 3
conditional formatting on date where today is > or = datevalue 3
Highlight the cell date of current month 3
Why is my conditional formatting highlighting the wrong dates? 1
macro for displaying conditional formatting 1
Date Calculation & Conditional Formatting 3
Conditional formatting of date-cell - 2007 5
Formatting cells containing certain words 1

Back
Top