Conditional Format (Todays Date)

[Kevin]

In column A, starting in row 5 I have dates, May 15, 2008 through to Sept 15,
2008. I am using a Conditional Format to highlight today’s date

=$A5=TODAY().

It is working great on one worksheet. I have made a another similar sheet,
and am trying to do the same thing. The dates on the second sheet start in
A3. I am using the same conditional format, but changing it to A3.

=$A3=TODAY()

The first one works fine, but the second one highlights the last cell, A110
Sept 15, 2008. Can someone please shed some light on this for me?

Thanks

Kevin

 

[Kevin]

I got it to work, I copy and pasted it onto a new worksheet and it worked.
Weird!

 

[OssieMac]

Hi Kevin,

I think that you have a problem in the way you are setting conditional format.

In pre xl2007 versions do the following:-

Select all the cells to have the conditional format.
Select Format->Conditional format
Under Condition1 select "Cell value is"
Next field click drop down and select "equal to"
Next field enter =TODAY()
Click format button and set required format
Click OK

In xl2007
Select all the cells to have the conditional format.
On Home ribbon select Conditional formatting
Select New rule
Under rule type Select format only cells that contain
"Cell value is" (Default)
Next field click drop down and select "equal to"
Next field enter =TODAY()
Click format button and set required format
Click OK