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

Change the color of a cell change dependant on a result
 

Look at formatconditional formatformula is

--
Don Guillett
SalesAid Software

"KFEagle" wrote in message
...
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

Change the color of a cell change dependant on a result
 

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