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

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

In article ,
alesia wrote:

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

Yes, you can use conditional formatting...

Format Conditional Formatting Formula Is

Hope this helps!

Use the condition part of the formula within conditional formatting.

Select the cells
Menu FormatConditionalFormatting
Change Condition 1 to Formula Is
Add the formula, such as A210
Click Format
Select Pattern
Pick a colour
Exit

--

HTH

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


"alesia" wrote in message
...
I would like cells to be filled with specific colors when an IF formula
results are true. Is this possible?