Conditional format entire row (not cell) by 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.
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
B

Bob Phillips

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)
 
S

Sherry

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.
 
D

Dave

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Click to expand...



Many thanks for your help.
 
Top