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

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

Guest

I would like cells to be filled with specific colors when an IF formula
results are true. Is this possible?
 
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!
 
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)
 
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

Excel VBA 1
Excel Macro to automatically go to the right of the last colored cell 0
Function for summing or counting cells based on a specified fill color 2
If function using cell format as the condition 2
Macro Fill Formula 1
Filling formulas with specific cell references remaining the same 1
CF to Color-Fill Row B:G w/Specific Text in One of the Cells 1
How to Color a Cell Based on a Range of Cells with Colors 1

Back
Top