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

B

binary-dinosaur

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!
 
C

Charles T. Garrett

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top