How do you...

N

Na'an

ok. I have some formulas set in Excel. Is there a way to make it so that
the number would automatically turn red if the outcome of the formula is a
negative number? Oh I have Office XP, incase that makes a difference.
 
N

Niek Otten

Look in HELP for Format>Conditional Formatting

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 
C

cgarrett1999

1-Select the cell(s)

2-Go to Format in the toolbar, Format > Conditional Formatting...

3-Condition1, choose "Cell Value Is"

4-Next drop choose, "Less than"

5-Place a "0" (zero) in the next box

6-Click the "Format..." button

7-Click the "Font" Tab

8-Click the "Color" drop down

9-Click on the RED square

10-Click the "OK" button

DONE!
 
Top