Highlighting today's row.

[Roger PB]

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

 

[Amedee Van Gasse]

Roger PB shared this with us in microsoft.public.excel.programming:

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

Does it not work with that formula? Perhaps you'll have to change it to
=$A1=today()

--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?

How To Ask Questions The Smart Way

How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoynePollard/FGA/questions-with-yes-or-n
o-answers.html

 

[Bob Phillips]

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]

Many thanks.

This worked fine, but I am not sure how to extend it for succeeding dates. I
dragged on the corner of the conditionally formatted cell,
but next day, only it, and not the entire row, was highlighted. So how or
where do I drag to get the whole row highlighted every day.?

 

[Bob Phillips]

Note the instructions

Select the whole row and amend the formula from


--

HTH

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