Formatting Color into cells

[Guest]

I'm working on a payroll spreadsheet and I have created an IF statement into
a cell. The problem is that I need the IF statement to put in either "Over
Budget" or "Under Budget" in the cells. If it it "Under Budget" I need the
cell to be green with the text. If it is "Over Budget" I need the cell to
turn red. How do I do this?

 

[L. Howard Kittle]

With your Budget in A1 and Actual in B1, in C1 enter:

=IF(A1>B1,"under budget","overbudget")

In C1 Format > Conditional Format >Formula Is > =A1<B1 > Format > Pattern >
Check Red > Ok > Add > Condition 2 > Formula Is > =A1>B1 Format > Pattern >
Check Green > OK > Ok

HTH
Regards,
Howard

 

[Biff]

Hi!

Select the cell in question.
Goto Format>Conditional Formatting
Condition 1
Cell value is
Equal to
Over Budget
Click the Format button and select the style you want.
OK
Click the Add button
Repeat the process for Under Budget
OK out

Biff