Hi
you have to enter a valid date. That is WITH a year. You can then
afterwards format it as
D-MMM

--
Regards
Frank Kabel
Frankfurt, Germany


KiriumF1 wrote:
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?