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?
|