View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Platypus Platypus is offline
external usenet poster
 
Posts: 4
Default Calculation for Effecting Pattern Color, Bold, Etc.

Could anyone provide me with the syntax for the following example:

If B1 0, turn the cell blue; if B1 <= 0, turn the cell red

-and-

If B1 0, make the font red; otherwise, leave as is.

Are these possible? Thank you in advance.