I'm trying to do exactly that--make it change cell color based on the
calculated value, and have more than 3 conditions. Is there a
modification to this that someone can suggest?

Thanks in advance for any insight anyone can offer.

Brian


Chip Pearson Wrote:
Note that Bob's code will run only when the cell's value is
changed by the user, not, as is the case with Conditional
Formatting, when the change is the result of a calculation.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


--
bkcoughlin
------------------------------------------------------------------------
bkcoughlin's Profile: http://www.excelforum.com/member.php...o&userid=32284
View this thread: http://www.excelforum.com/showthread...hreadid=507761