Conditional Formating help needed.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 30 Nov 2006 16:50 GMT

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.

Reply to this Message

Bob Phillips - 30 Nov 2006 16:54 GMT

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

--

HTH

Bob Phillips

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

> 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
[quoted text clipped - 6 lines]
>
> Any suggestions would be welcome.

Reply to this Message

Chris - 01 Dec 2006 06:12 GMT

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.

> =AND(--"2006-10-07"<=TODAY(),TODAY()>=--"2006-10-10")
>
[quoted text clipped - 16 lines]
> >
> > Any suggestions would be welcome.

Reply to this Message

Chris - 01 Dec 2006 06:24 GMT

Is as simple as reversing the greater than and less than symbols?

> Bob.
>
[quoted text clipped - 25 lines]
> > >
> > > Any suggestions would be welcome.

Reply to this Message

Chris - 01 Dec 2006 07:26 GMT

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?

> Is as simple as reversing the greater than and less than symbols?
>
[quoted text clipped - 27 lines]
> > > >
> > > > Any suggestions would be welcome.

Reply to this Message

Rate this thread: