Hi,

give this a try, works fine for me.

In the conditional formatting box change to 'Formula Is' and set the formula
to:
=$A$1=TODAY()



Marc

"Kinghart" wrote:


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