Conditional Formatting of Dates (Multiple Criteria)

[DocAElstein]

Hi
_1 What is the error?
_2 can you upload a small amount of test data where you have the error , ( Change any personal or senstive data )
Alan

[msiyab]

Hi
_1 What is the error?

Run-time error '13':
Type mismatch

_2 can you upload a small amount of test data where you have the error , ( Change any personal or senstive data )
Alan

Sorry its a company worksheet, with multiple formula, links, etc.

[DocAElstein]

Hi
I expected that it might be that type of error. Such an error is typical when tying to compare dates.
I cannot help further without some test data.
I only need column A and column N.
Can you upload a small sample with just column A and column N. You can delete all other information. I only need to see the two columns of dates.

[msiyab]

Cheque Book Register.xls

I have attached a sample workbook

Please note, I have added a few more columns. So the previous Column N is now Column L in the new file.