Could you use conditional formating instead?

select Format, Conditional Formatting from menu

then select "formula is" in box
Type =a112
(assuming a1 is your cell with the number in)
any cells formatted like this will change colour depending on the vaue
in a1.

you can copy the format to other cells and the reference moves as
normal depending on whether you make it absolute or not ($$)

Ruth


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=383551