Select the whole row and amend the formula from

=A1=TODAY()

to

=$A1 = TODAY()

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Roger PB" wrote in message
...
I have a number of spreadsheets where the first column contains the date,
conditionally formatted with =A1=today(), copied throughout the column,
i.e.
=A2, A3, etc. The conditional formatting makes the cell red, so I can
instantly find today's row.

However, I would like to extend the red colour to the rest of the same row
on the sheet. How can I do this using either the condional formatting
menu,
or with a VBA macro?

Roger PB