A cute Excel conditional formatting quirk

Let's say I conditionally format cell A10 based on the contents of cell A1 using the formula bit of the conditional formatting feature and leaving A1 undollared. I then copy A10 in its entirety to A9. Because Excel can’t base its formatting on A0 (as such a cell doesn’t exist), it instead bases it on A65536.

Quite cute really.

This entry was posted in Quick tips and tagged . Bookmark the permalink.