Sorry to revive a dead thread but I've got a similar question concerning the conditional AND.
http://www.excelforum.com/showthread.php?t=645560
Simply put if I've got cell A1 and I want it to turn yellow when both the conditions of...
A2=5
A3=5
Then what would I put into the conditional formatting options?
Bookmarks