Excel Formula using colors

P

Powell

A while ago, I was able to write a formula that allowed me to use the "if"
function to format a cell a specified color. If the condition of the if
statement was met, the cell that contained the formula would turn the
designated color. I have no used this formula in a long time and can't recall
how to make it work. Any help would be appreciated. Thanks.
 
D

Duke Carey

You'll find that option under Formatting->Conditional formatting.

In the first drop-down select "Formula Is..." and then enter your IF formula
in the editing box. Click on the Format button and select the options to
apply when the formula is TRUE
 

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
Using Three Conditions in CF 3
IF OR AND in same conditional formula 2
If function using cell format as the condition 2
How to Color a Cell Based on a Range of Cells with Colors 1
If then Statements in Excel 4
Can I color a cell with "If" formula 2
Using Dates in Conditional Formatting 9

Top