How to return formatting to cells rather than value for "IF" cmnd

N

nbspacenut

Can formatting of cells be returned after an "IF" logic formula rather than a
value?
I'd like to have cells be colored when a specified cell has a specific
number entered in it when the "IF" statement is true and not colored when the
"IF" statement is false.
 
J

John C

Say you want B2 to be blue if A1 is =5

For the Conditional Format formula for B1, use the drop down box to Formula Is
=A1=5, then choose your format (blue in this case).
 
Top