Change the color of a cell change dependant on a result

I need to make a cell change color dependant on a formula.
For example, if sum(A1+A2)>=100 then change cell color to red

Look at format>conditional format>formula is

--
Don Guillett
SalesAid Software
[email protected]
"KFEagle" <[email protected]> wrote in message
news:[email protected]...
> I need to make a cell change color dependant on a formula.
> For example, if sum(A1+A2)>=100 then change cell color to red

Hi KFEagle,

> I need to make a cell change color dependant on a formula.
> For example, if sum(A1+A2)>=100 then change cell color to red
>

Insert that formula into the Formula Is option of the Conditional
formatting dialog (Format, Conditional format)

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com