Conditional formatting with if statement in Excel
I have a spreadsheet with budget figures and I am trying to use conditional
formatting to show increases from one month to another by a certain percentage.
Cell H26 has a July amount.
Cell I26 has a Aug amount.
Using conditional formatting, I want to show when the expensed amount in August (I26) is greater than July (H26) by 80% turning it red with conditional formatting. If Aug is less than July by %80 it should do nothing.
Use the "value is greater than" in conditional formating.