Conditional format entire row (not cell) by date

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hi,

please can someone assist me with the following:-

I am looking to colour code entire rows dependent upon their date.
For example:-
11-30 days old Green
31-60 days old Blue
60+ days old Red

It appears that conditional formatting allows you to do format a
particular cell but not the entire row. I am also looking to include
this in a standard recorded macro (as opposed to a self written one).

If anyone can help with a) the above formula and b) the conditional
formatting it would be appreciated. I have searched but cannot find
an answer to this particular issue.

Many thanks.
 
Hi Dave!

I think this is what you want:

If your date is in A1
Select Row 1

First format formula is
=TODAY()-$A$1>60 Format Red
Second format formula is:
=TODAY()-$A$1>30 Format Blue
Third format formula is:
=TODAY()-$A$1>10 Format Green

That leaves the default format for <=10

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Small point. If you want to set more than 1 row, select all of the rows at
the same time, and use the formulae

=TODAY()-$A1>60 Format Red
=TODAY()-$A1>30 Format Blue
=TODAY()-$A1>10 Format Green

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
It appears to me that once you set your formula and your
conditional formatting in a cell, you can then "fill" and
the conditional formatting will carry on to subsequent
cells. I just played around with this out of curiousity,
so I many not be actually grasping your concept. Feel free
to email if I can help.
 
Norman Harker said:
Hi Dave!

I think this is what you want:

If your date is in A1
Select Row 1

First format formula is
=TODAY()-$A$1>60 Format Red
Second format formula is:
=TODAY()-$A$1>30 Format Blue
Third format formula is:
=TODAY()-$A$1>10 Format Green

That leaves the default format for <=10

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Click to expand...



Many thanks for your help.
 
Back
Top