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?

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

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Ben Joseph" wrote:

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?

Thanks Luke. This worked just like you explained.

"Luke M" wrote:

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

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Ben Joseph" wrote:

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?