IF Formula

S

SilviaG

I have formula =min(312,200+8) and im trying to add the IF function to it as
well, with the logic that if 0<312 that the text will change a certain color
if true and a different color if its false. Is there a way to do this?
 
D

Dulanic

I have formula =min(312,200+8) and im trying to add the IF function t
it as
well, with the logic that if 0<312 that the text will change a certai color
if true and a different color if its false. Is there a way to d
this?



Use conditional formatting? Functions can't change formatting itself.
 
D

David Biddulph

To change colour based on a condition, the feature you want to look up in
Excel help is "conditional formatting".
 

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

Top