Conditional Formatting of Dates (Multiple Criteria)

[DocAElstein]

The final coding is your final code. That is the only coding that you need
But
You need to put that in a worksheet code module, the worksheet code module for worksheet “Cheques” - The steps before are to explain to you how to do that. The procedure , Private Sub Worksheet_Change(ByVal Target As Range) , will not work in a normal code module. It must be put in worksheet code module for worksheet “Cheques”


Edit: attached File is in final form

[msiyab]

Yippi!! Its working now.

Thanks a lot DocAElstein. Thanks for being so patient and really appreciate the explanation given (step-by-step)

[DocAElstein]

..Thanks a lot ...

Yous welcome, thanks for the feedback :-)
Alan