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.
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?