Coloring Cells
 

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

Use conditional Formatting...


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=390718

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