Mmmm, i typed in 1st january as "1-jan" but when i click on the cell, it
shows 1/1/92. So not sure whether this is text or dates?

"Frank Kabel" wrote:

Hi
are you sure your date values are stored as 'real excel' dates and not
as 'Text'.

Also in your example:
- select B3:B2000
- goto the conditional format dialog
-and enter only
=MONTH(B3)=6

--
Regards
Frank Kabel
Frankfurt, Germany

"KiriumF1" schrieb im Newsbeitrag
...
Mmm, nothing happens, the dates are in the column B and there are
about 2000
over rows. Should i put B3:B2000 or just B1? Both ways nothing
happened.

"Alan Perkins" wrote:

Select conditional formatting, and under condition 1, select
"Formula is",
and in the formula, type "=MONTH(B1)=6" (for June), and change the
6 to 12
for December.

HTH

Alan P.


"KiriumF1" wrote in message
...
in column B, i have dates in the form 1/1/92 to 31/12/92, how do
i write
the
conditional formating, so that i can highlight particular
months...for
example, all june will be red, or all December will be red?