conditional format
 

I would like an entire row (A-R) to be highlighted if it is todays 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 todays date in column
A I would like the whole row A-R to be highlighted.

I am using office 2007

conditional format
 

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

"Kevin" wrote:

I would like an entire row (A-R) to be highlighted if it is todays 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 todays date in column
A I would like the whole row A-R to be highlighted.

I am using office 2007

conditional format
 

thanks mike that works great
"Mike H" wrote:

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

"Kevin" wrote:

I would like an entire row (A-R) to be highlighted if it is todays 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 todays date in column
A I would like the whole row A-R to be highlighted.

I am using office 2007