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

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
http://www.catb.org/~esr/faqs/smart-questions.html
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.deBoyn...-with-yes-or-n
o-answers.html

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

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" schrieb im Newsbeitrag
...
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

Note the instructions

Select the whole row and amend the formula from


--

HTH

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


"Roger PB" wrote in message
...

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" schrieb im Newsbeitrag
...
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