Formatting Color into cells
 

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(A1B1,"under budget","overbudget")

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

HTH
Regards,
Howard

"HR Manager" <HR wrote in message
...
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?

Hi!

Select the cell in question.
Goto FormatConditional 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

-----Original Message-----
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?
.