| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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! |
|
#3
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
| Copy Paste of Formula Produces Incorrect Result | Excel Discussion (Misc queries) | |||
| reference the result of a formula in a text formatted cell | Excel Discussion (Misc queries) | |||
| Formulas appear in cell instead of formula result | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
