Cheque Book Register 11Feb.xls

The highlighting of cells when Column A is blank has gone. It is even highlighting if the date in Column A is 150 days or older.


However, If you check Rows 79 & 81 in the attached excel above, Column A is still highlighted even though I have entered the clearing date in Column L.

Can you create a condition that if there is any date in Column L, Column A should not be highlighted irrespective of the date being 150+ days old in Column A.