You're welcome !
Formula Is| =AND(TEXT(C4,"mmmm")=$C$2,C4<"")
The ... C4<"" condition is included to prevent any blank cells within the
source range from "wrongly" triggering the CF when C2 = January
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"David" wrote in message
...
Max wrote
Formula Is| =AND(TEXT(C4,"mmmm")=$C$2,C4<"")
Excellent!!! Reducing to =TEXT(C4,"mmmm")=$C$2 works as well, although I
can see why the test for blanks might come in handy someday.
Thanks.
P.S. While waiting for a response I was able to type 2/1 (that makes
changing months easier) in C2 and custom format as mmmm and achieve what I
wanted with:
Formula is|=MONTH(C4)=MONTH($C$2)
The secret was making C2 absolute, which I had overlooked in previous
trials.
--
David
|