Format Cells based on start & end date!

[mykal66]

Hi everyone

Is it possible to automate the formatting of the months cellsin the attached example workbook based on the start & end date columns? At the moment everyone does it manually so I’vetried messing with conditional formatting but can’t get anything to work.
Thank you as always for any help or pointers in rightdirection
Mykal

[Bob Phillips]

Does this CF formula do what you want to do?


=AND(TEXT($A3,"yyyymm")<=TEXT(C$2,"yyyymm"),TEXT($B3,"yyyymm")>=TEXT(C$2,"yyyymm"))

[mykal66]

Does this CF formula do what you want to do?


=AND(TEXT($A3,"yyyymm")<=TEXT(C$2,"yyyymm"),TEXT($B3,"yyyymm")>=TEXT(C$2,"yyyymm"))

Hi xld

Absolutely prefect and thank you very much for your helptoo, very much appreciated.

Mykal