Select the range to be conditionally formatted,
eg select B3:B5 (with B3 active),
then apply CF using "Formula is" as follows:
Condition 1, Formula is:
=AND(B3<"",B3-$A$1<=0)
Format Red fill
Condition 2, Formula is:
=AND(B3<"",B3-$A$10,B3-$A$1<=90)
Format Yellow fill
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Potaroo" wrote in message
...
Hi all,
I need to place conditions on a spreadsheet dealing with dates.
In a column I have dates eg 28 Aug 07, 15 May 07, 20 Jun 08 etc
Lets say they are in cells B3, B4 and B5 respectively.
At cell A1 there is a date =TODAY()
In the B column I have placed conditional formatting as
Cell Value Is: Equal or greater than $A$1 - it returns a cell coloured
RED
I'm at a loss to place a value in for those dates between Cell A and those
in Column B from day 1 to day 90 (ie within 3 months) to return a colour
of
Yellow
Hope you can understand my query,
Cheers, Pete.