Change the color of a cell change dependant on a result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
Click to expand...

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need urgent help 0
Change the color of a range of cells. 6
Change Color of cell 3
Change cell color 1
Remove Hyperlinks Without Changing background shading 14
Excel VBA 1
Inserting formulas depending on a variable 2
How to code macro for worksheet? 4

Back
Top