Change cell color in Excel according to adjacent dropdown value

Posted by Andrew Heath on Stack Overflow See other posts from Stack Overflow or by Andrew Heath
Published on 2010-04-14T03:09:04Z Indexed on 2010/04/14 3:13 UTC
Read the original article Hit count: 280

I understand how to make a dropdown list.
I understand how to make conditional formatting change the color of a cell.

What I do not understand is how to make conditional formatting change the color of a cell based solely on the state of another cell (not a comparison).

A1 is a No / Yes dropdown list

B1 is a criteria statement

If the user satisfies the criteria statement in B1, they select Yes on the dropdown list in A1. For quick reference, if possible, I'd like B1 to change to a green background color on this event... and of course change back to no-fill if the dropdown is reset to No.

Is this possible in Excel 2003 and/or 2007?

© Stack Overflow or respective owner

Related posts about excel

Related posts about conditional-formatting