View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default 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.