Excel: Apply Conditional Formatting with Multiple Conditions


Often you may want to apply conditional formatting to cells based on multiple conditions in Excel.

The following example shows exactly how to do so.

Example: Conditional Formatting with Multiple Conditions

Suppose we have the following dataset that contains information about various basketball teams:

Suppose we would like to highlight each value in the points column where the value is greater than 10 and less than 20.

To do so, highlight the values in the range B2:B14, then click the Conditional Formatting icon on the Home tab, then click New Rule:

In the new window that appears, click Use a formula to determine which cells to format, then type in the following formula into the box:

=IF(AND(B2>10, B2<20), TRUE, FALSE)

Then click the Format button and choose a fill color to use, then click OK:

Excel conditional formatting multiple conditions

Each value in the points column that is greater than 10 and less than 20 will automatically be highlighted:

Note: You can find the complete documentation for the AND function in Excel here.

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

How to Apply Conditional Formatting if Cell Contains Text in Excel
How to Find the Top 10% of Values in an Excel Column
How to Find the Top 10 Values in a List in Excel
How to Find Unique Values from Multiple Columns in Excel

Leave a Reply

Your email address will not be published.