Table of Contents
Conditional formatting in Excel allows you to quickly and easily format cells based on specific rules. You can highlight cells that meet certain criteria, such as numbers greater than a certain value, dates that fall within a certain range, or text that contains specific words. Conditional formatting can help you quickly identify patterns, trends, and outliers in your data, making it easier to analyze your data and draw conclusions.
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:
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 .
How to Apply Conditional Formatting if Cell Contains Text in Excel