I have these cells in row 69:
W X Y Z
-44.21 0 0 -42.34
I want to conditionally format the cell in W69 if Z69 < 0 AND W69 < Z69
This formula works:
(Z69 < 0) AND (W69 < Z69)
But when I copy the cell 'W69' (CTRL+C) and then paste special to cell W70 (ALT+SHIFT+V and only select 'Formats" the cell is not highlighted even through the condition is true. I can double check that the paste was valid (Format-Cond. Formatting) and the formula is correct.
What is going on? Why is the formula not working?