Wednesday 18 October, 2006

Cute Excel conditional formatting quirk

Filed under: All things Excel

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.


Posted by dan at 9:18pm | Permalink | Comments (0) | Trackbacks (0)
Comments
Add comment (all comments are currently moderated)
Your name*
Enter the confirmation code* You don't have GD support compiled in, we cannot create an authimage. Please activate GD Support.
Comments *



* denotes a mandatory field