conditional format

[Guest]

I would like an entire row (A-R) to be highlighted if it is today’s date. In
column A I have dates. I used a conditional format on cells A5:R187
=INT(A5:R187)=TODAY() this works, but only highlights today’s date in column
A I would like the whole row A-R to be highlighted.

I am using office 2007

 

[Guest]

Kevin,

Select your range by selecting A5 and dragging to select all cells.
Then
Format|conditional formatting|formula is

=$A5=Today()

choose a colour.

Mike

 

[Guest]

thanks mike that works great

Kevin,

Select your range by selecting A5 and dragging to select all cells.
Then
Format|conditional formatting|formula is

=$A5=Today()

choose a colour.

Mike