Yes, it won't work.
The easiest thing is to use Autofilter on the fly. It's on the Tools menu.
So long as your data table is contiguous, I.e. no blank rows or columns, you can easily FILTER out for today's date which will show up in the dropdown, or use Custom filter and enter the date when the value is equal to the date.
Selecting All will revert the display to all rows.
If you insist on coloring (how do you filter for 'red' I always wonder), you may need to have a column next to your dates where you say date in col.F=today(),set it to -1, otherwise 0, and then you can make the negatives red using the built in conditionals or one of the built-in formats for numbers.
=IF(F4=TODAY(),-1,0) but that'll color the flag cell and not the cell left of it where the date is.
Finally, you can, in the conditional dialog enter 12/4/2007, but I'd think that's a pain. The Autofilter is simpler, even if it might require some redesign on your part, like elimination of blank rows or columns (remember, you can always widen the size of those if it's visually important).
Hope something from here will help you
Edited by tos226, 04 December 2007 - 11:56 AM.