Coloring Cells

[Gabbi]

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

 

[kraljb]

Use conditional Formatting..

 

[Bob Phillips]

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)