Prev: NK2 not corrupt but not being seen
Next: How do I change a drop down list?
From: rebecca on 25 Jan 2010 10:19
In conditional formatting I would like a certain row of dates to turn a
colour when a report is sue in 60 days and they a different colour when there
due in 30 days. Also included in the formula I need the colour to remain
blank if there are no dates in the column
From: Bernard Liengme on 25 Jan 2010 13:09
In A9 I have the date 1/Nov/2009
In B10 I have =A9+15 and this is copied across to L9
So I have a row of dates in 15 day steps
I selected A9:L9 and used this formula in the Conditional Formatting dialog
=A9>TODAY()+60 (colour red)
Then I added
=A9>TODAY()+30 (color blue)
So I want to know what dates are 60 days and 30 days in advance of today's
date
The last two cells with 31/Mar and 15-April got highlighted red
The two before that are blue
Note that I must put the 60 day one first; otherwise all the last 4 cells
would be blue !

Need more help? Tell us what version of Excel and be a little clearer about
your needs. Are the dates you mention the due dates of the report?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"rebecca" <rebecca(a)discussions.microsoft.com> wrote in message
news:06E0BF67-FF52-4DF4-A094-38D847AA264F(a)microsoft.com...
> In conditional formatting I would like a certain row of dates to turn a
> colour when a report is sue in 60 days and they a different colour when
> there
> due in 30 days. Also included in the formula I need the colour to remain
> blank if there are no dates in the column

 | 
Pages: 1
Prev: NK2 not corrupt but not being seen
Next: How do I change a drop down list?