If you use B1 in the formula is B1 the active cell within your selection?
in other words select the entire B column with the top row visible
when you do that.

If you wanted to color entire rows you would use $B1 in the formula
=MONTH($B1)=6
and obviously choose a pattern color under format.

http://www.mvps.org/dmcritchie/excel/condfmt.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"KiriumF1" wrote in message ...
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?