How to Combine Conditional Formatting with an IF Statement

How to Combine Conditional Formatting with an IF Statement

The following will help to understand the steps on how to combine conditional formatting with an if statement.

If you are in a rush and want your problem answered, email to or live chat with us.


  • I have set of numbers placed in column A and want to highlight the numbers that are grater than 0.
  • Conditional formatting is the best option to highlight the cells that are under consideration.
  • There are various methods to highlight the cells in conditional formatting. However, in this example, let’s use custom formula option with an if statement.
  • Select the cells that contain the numbers and click on the following:
  • Home > Conditional Formatting > New Rule.
  • A pop-up box opens. Please select the last option “Use a formula to determine which cells to format”
  • Enter the following formula in the text box, that uses If function to check whether the numbers are greater than or not?
  • =if(A1>0,True,False)
  • Click on the Format button located next to the text box.
  • Click on Fill Tab, and select green colour.
  • Click Ok to apply the conditional formatting.
  • Now, you will see the cell that contain positive numbers are filled with Green colour.
  • Thus, conditional formatting tool in Excel is very helpful and cells can be highlighted with an if statement based on the custom formula.


About the author: admin

You must be logged in to post a comment.