Problem with cell shading

[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

[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)

"Mark J" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> Mark J
> ------------------------------------------------------------------------
> Mark J's Profile:
http://www.excelforum.com/member.php...o&userid=30738
> View this thread: http://www.excelforum.com/showthread...hreadid=504376
>