Can an IF formula result in a color filled cell in Excel?

A

alesia

I would like cells to be filled with specific colors when an IF formula
results are true. Is this possible?
 
D

Domenic

alesia said:
I would like cells to be filled with specific colors when an IF formula
results are true. Is this possible?
Click to expand...

Yes, you can use conditional formatting...

Format > Conditional Formatting > Formula Is

Hope this helps!
 
B

Bob Phillips

Use the condition part of the formula within conditional formatting.

Select the cells
Menu Format>Conditional>Formatting
Change Condition 1 to Formula Is
Add the formula, such as A2>10
Click Format
Select Pattern
Pick a colour
Exit

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top