Hi, one problem could be language specific settings. Can you try to copy any of the other (already existing) formulas for conditional formating,m while standing in a date cell and paste it into the forum. Preferrably choose a formula that has this VLOOKUP function (I can't describe more accurate at the moment, no Excel on this computer).

Kind regards
Bjorn