You need conditional formatting.

Look up 'Highlight cells that meet specific conditions' in the Answer
wizard in help


--

HTH

RP
(remove nothere from the email address if mailing direct)


"madhatter" wrote
in message ...

i want to change the color of a cell if another cell has a value of
greater than 12.
what is the input i use in the IF function to change the color of the
cell?
=IF(E312, ? , ? )
can someone help me.

thanks


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