Conditional formatting =TODAY() works for d (date), not for mmmm (month). Help!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AA Arens - 24 Jun 2007 02:49 GMT

I am able to use conditional formatting with "value equal to"
=TODAY(), on a cell that is formatted as d (date)

But I failed to do use the same conditional formatting for a cell with
format "mmmm" (example: June).

Help.

Bart
Excel 2003.

Reply to this Message

Dave Peterson - 24 Jun 2007 03:51 GMT

Does that cell contain June or does it contain a real date?

If it contains a real date, is it today?

> I am able to use conditional formatting with "value equal to"
> =TODAY(), on a cell that is formatted as d (date)
[quoted text clipped - 6 lines]
> Bart
> Excel 2003.

Signature

Dave Peterson

Reply to this Message

AA Arens - 24 Jun 2007 14:34 GMT

Its contains 01-06-2007, but with June it doesn't work either with the
same format (mmmm).

Bart

> Does that cell contain June or does it contain a real date?
>
[quoted text clipped - 14 lines]
>
> Dave Peterson

Reply to this Message

Rate this thread: