Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: want neg numbers to show red/pos green via if-then formula | Excel Worksheet Functions | |||
Green arrow in cells | Excel Worksheet Functions | |||
Show +/- totals in formulas in green vs. red colors | Excel Worksheet Functions | |||
Can i add up all green filled cells in a workbook? | Excel Worksheet Functions | |||
How do I get excel to add cells by color? Like all green cells (s. | Excel Discussion (Misc queries) |