See conditional formatting in help.

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)


"Gabbi" wrote in
message ...

If this is my matrix for accounting...

0.0% = green
0.0/-5.0 % = yellow
< -5.0% = red

and I want the entire cell surrounding the solution to correlated to
the color scheme mentioned above, what function would I use to do
that?

G


--
Gabbi
------------------------------------------------------------------------
Gabbi's Profile:
http://www.excelforum.com/member.php...o&userid=25654
View this thread: http://www.excelforum.com/showthread...hreadid=390718