Hi, Best doing this with conditional formatting, choose your cell select
Formats, Conditional Formatting then click the drop down box next to
Cell Is and select Formula is, assuming you are using Cell A1 type in
the box =A10 then choose formats, patterns and then select your
colour, now click add do the same as above only this time type =A1<0
and choose formats, patterns and your colour, then copy the cell over
as many as you like.

Hope this helps!

regards,

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=546296