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

  • Thread starter Thread starter AA Arens
  • Start date Start date
A

AA Arens

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.
 
Does that cell contain June or does it contain a real date?

If it contains a real date, is it today?
 
Its contains 01-06-2007, but with June it doesn't work either with the
same format (mmmm).

Bart
 
Back
Top