Formatting Color into cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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
 
Back
Top