I want cells to show green if <10% and red if10%. please help
 

First select and highlight the cell(s) you want to use.
Format Conditional Formatting
Select
"Cell value is"
"Less than or equal to"
".1" (place decimal point one in the selection)
Now click the "Format" button and select the "Pattern" tab and select your
shade of green.

Now click the "ADD" button to get Condition 2, and do the same thing again
except put "greater than or equal to" and put ".101"(place decimal point
one-zero-one in the selection), select format and your shade of red.


"binary-dinosaur" wrote in
message ...
I am trying to make cells show a green background if the result is less
than
10 and a red background if the result is grater than 10 I am relatively
new
to Excel and although I have spent some time trying I cant work this one
out.
Pleas Help!