Problem with cell shading

M

Mark J

If a table like this


Var00

860%
2518%


-40%
60%
8%


I want to color the cell red when they are > 10% positive
And green if they are when they are < 10 negative
 
B

Bob Phillips

Select all the cells, starting at let's say A2

Menu Format>Conditional Formatting
Change Condition 1 to Formula Is
Add formula of =A2>.01
Click Format
Select Pattern tab
Select red
OK

Click Add>>
Change Condition 1 to Formula Is
Add formula of =A2<-.01
Click Format
Select Pattern tab
Select green
OK

OK

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top