I have been reqeusted to produce a spreadsheet to which a cell will have
a three digit positive number (but can be text or even a formula if
needed) in it such as 747. I need the contents of this cell to change
colour depending on the results of a formula in another cell. (Is one
cell smaller, equal to, or larger than another cell). Red if negative.
Blue if 0. Green if positive. Can somebody please help me with this

Thanks
Martin


--
Martin


------------------------------------------------------------------------
Martin's Profile: http://www.excelforum.com/member.php...nfo&userid=191
View this thread: http://www.excelforum.com/showthread...hreadid=537232