IF Statements

  • Thread starter Thread starter Ben Joseph
  • Start date Start date
B

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