Calculation for Effecting Pattern Color, Bold, Etc.

P

Platypus

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.
 
B

Balzyone

Conditional formating is the way to go with this. If you look into the
format-conditional formating, the dialog will allow you up to 3 conditions
and allow you to change the cell color, borders, and font under the
conditions you select. It is very simple to figure out.
 
Top