It's possible to do it under one rule if you are applying the conditional formatting within the cell in question... but because the cell color depends on a different cell, I think this is the only way to do this... I could be wrong though... anybody know?
Bookmarks