Are you talking about the red highlighted cell? If so, then it works in my workplace (Excel 2007). Thank you for your solution.

It seems that structured referencing does not work in the conditional formatting in Excel 2007.