IF Statements

[Ben Joseph]

I have in my spreadsheet a number for Budget and a space for putting in
amounts spent. I have an IF statement which displays the words "YOU HAVE
EXCEEDED THE BUDGET FOR THIS SUB-PROJECT" if the amounts spent exceed budget.
Is it possible to use the IF statement to display a red flag when this
happens?

 

[Luke M]

Actually, you want to use conditional formatting (Format - Conditional Format)

Either set the cell to display red (either change font color, or pattern)
when those words or displayed, or use a formula with something like
=A1<B1

 

[Ben Joseph]

Thanks Luke. This worked just like you explained.