Danny,
It looks like the rounding solution worked, but if you are
concerned about rounding for downstream calculations why not set up
your conditional fortting based on the unrounded results.

ie.
if your value is between 2.51 and 3.50 it will round to 3 and you want
it red
if your value is between 3.51 and 4.50 it will round to 4 and you want
it yellow
if your value is above 4.51 it will round to 5 and you want it green.

So set up your conditions accordingly.
Rather than value = 3 turns red
have value between 2.51 and 3.50 turns red

etc.

Just a thought.


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=366718