MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Conditional Formatting


Posted by Rob on July 30, 2001 4:06 PM

I was looking for a topic I saw posted last week (maybe its gone) that was about conditional cell formatting based on a TODAY condition. How do i get this to work? I would like to test a cell for todays date in the format of mm/dd/yy and if it is the same as today, then format the cell accordingly. I know Aladin answered this question, but cant find the thread. thanks


Posted by Corey on July 30, 2001 4:13 PM

Try this:

Format
Conditional Formatting
Condition 1:
"Cell Value is" "Equal to" "=today()"
Then select your formatting

Posted by Aladin Akyurek on July 30, 2001 4:19 PM

Give a background color to a cell if it contains a date that is equal today's date. Is this what you want to do?

Posted by Rob on July 30, 2001 4:35 PM

Yes, thats it, thanks :)

Posted by Rob on July 30, 2001 4:37 PM

OK, another problem :(

I did the conditional formatting, and it works fine, but I have a workbook with 10 worksheets, each with the full range of cells using conditional formatting. The problem is, its taking the file about 2 min to open up. Is there a way to increase the speed? I tried using dynamic names for the Condition to check, but it wouldnt work. Thanks for the help in advance :)

Posted by Aladin Akyurek on July 30, 2001 4:48 PM

Re: OK, another problem :(

If you use =TODAY() everywhere, you could enter this formula in a cell of its own and name this cell e.g., DateNow, then use

=DateNow

I don't believe it would make much difference, unless you have thousands of cells where it will be used.

Aladin