View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Alan Perkins[_3_] Alan Perkins[_3_] is offline
external usenet poster
 
Posts: 4
Default how to do the conditional formatting for this?

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?