Conditional Formating help needed.

C

Chris

I want to apply conditional formatting to a group of cells, such that
if todays date - TODAY() - is greater than the date number for 16/10/07
(39371), but less than the date number for 16/10/10 (40467), i.e.today
is between these two dates, distinctive formatting is applied to the
cells.

I can do the formatting bit, but don't know what to put in for the
formulea.

Any suggestions would be welcome.
 
B

Bob Phillips

=AND(--"2006-10-07"<=TODAY(),TODAY()>=--"2006-10-10")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
C

Chris

Bob.

Thanks for the suggestion, however I can't make this work.

The conditional formatting is applied to todays date 01/12/06, which is
outside of the range specified 16/10/07 > 16/10/10. I am nowhere near
an expert, or even vaguely knowledgable on this but I would have
expected an IF in there somewhere.
 
C

Chris

Thanks again Bob.

I've settled on

=AND(TODAY()>=DATEVALUE("16/10/2007"),TODAY()<=DATEVALUE("16/10/2010"))

Can anyone see anything wrong with this?
 
Top