View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Conditional Formatting query

Hi

You say the cells are formatted as Date, but was this before or after
data was entered?
What do you get if you enter a formula on the sheet =B3+1?

Max's formulae should work perfectly, what result are you seeing?

--
Regards

Roger Govier


"Potaroo" wrote in message
...
Oh Max, it didn't work ;-(
Checked, made sure that the cells were formatted the same, ie "Number"
"Date" 08-Jun-07" etc, but to no avail.



"Max" wrote in message
...
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.