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
