Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting based on Formula | Excel Worksheet Functions | |||
Conditional formatting based on if statement. | Excel Worksheet Functions | |||
How to do a conditional formatting based on an adjacent cell | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |