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.
=IF($I26-$H26>0,$I26-H26/I26>0.8,0)
Bookmarks