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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks