IF () program

[Guest]

I've been using the IF () program/pragma for conditional statements and it's
been working well for me. Now, I want to use it for a special condition. If,
for example, if a group of cells is, say, under $100.00, I want my targeted
cell to print that summed $100 in red font. This is similar to formatting a
cell to the currency format but the font color automatically changes to red
(when the currency value id under $0.00). Suggestions?

 

[SamuelT]

Hi,

Do: Format>Conditional Formatting.

Then do:

Cell Value : Is Less Than : 100

Then just pick what formatting you want.

SamuelT