The formula is correct, so it must be your data that's wrong.

The typical problem is that your data is not a date, it's text. Try actually
entering 11/16/08 in the cell to see if that works. If it does, then all you
have to do is change your data from text to a date. Text to Columns is one
of the better ways.

Regads,
Fred.

"Kinghart" wrote in message
...

hi experts.... can u tell me to highlight today in a table using
conditional formating. I used this formula, but it didn't work
=today() and selected the RED colour




--
Kinghart