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. 

=IF($I26-$H26>0,$I26-H26/I26>0.8,0)

Answer:

Use the "value is greater than" in conditional formating.

conditional formatiing

 Other excel answers

 

 

You can find similar Excel Questions and Answer hereunder

1) Is there a way to create an visually impactful report with stop lights indicating automatically if Target is met?

2) How to change the color of gridlines in a worksheet in Excel

3) Formula does not calculate in Excel

4) Millions thousands custom number formatting in Excel

5) Sumifs with date range as criteria in Excel

6) Is there a way I can round the sales figure to the nearest 500?

7) Can I apply formatting to a number concatenated with a Text?

8) How can I clear all formats (formats alone not data) from a range of cells?

9) Autofill a b c d aa ab in Excel

10) How do I copy a Table from one location to another and retain all formulas, formats and columnwidths?

 

Here the previous and next chapter