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

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.

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

Look up conditional formatting in help

--


Regards,


Peo Sjoblom

"nbspacenut" wrote in message
...
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.

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

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).
--
John C


"nbspacenut" wrote:

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.