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