Allright, now the color changes, but it also keeps the color when the
value is changed.
For example:
target : 150
If the result is below this value, it turns red. But it stays red even
when the result is above this value, even though I've set the settings
at smaller than...? how can this be?


--
Fedde
------------------------------------------------------------------------
Fedde's Profile: http://www.excelforum.com/member.php...o&userid=30900
View this thread: http://www.excelforum.com/showthread...hreadid=522530