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 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
Hi, I am hoping you can help, I have a spreadsheet where I have entered a date and the next cell calculates the date in 6 weeks time. I have added conditional formatting to make the 6 weeks date turn red if that date has passed todays date. The issue I am having is that the spreadsheet is to track when certain things have been actioned, so if the date was fine and not an issue and everything was actioned, I don’t want the cell to turn red at a later date when I revisit the spreadsheet. Am I correct in thinking I need to add a new rule in to reflect this? To give you an idea of what I need, I have a date at when I received information, the next column has the 6 weeks date as the deadline, the following column has the date it was allocated. So everything was fine when it was actioned etc, I don’t want to look back at the spreadsheet for that cell to turn red because the date I am accessing the spreadsheet is past the 6 weeks date. Can you help? Thanks in advance
Hi Kristy…To achieve your goal, you can use a combination of conditions for your conditional formatting. Specifically, you need to add an additional condition to check whether the task has been actioned (based on the “allocated” column), and only then apply the formatting rule to highlight overdue dates.
### Steps to Set Up Conditional Formatting:
1. **Determine the logic**:
– Check if the “6 weeks date” is past today’s date (`TODAY()`).
– Ensure the “allocated” column is blank (indicating the task hasn’t been actioned).
2. **Steps to Add Conditional Formatting**:
– Select the range of cells in the “6 weeks date” column that you want to apply the formatting to.
– Go to **Home** > **Conditional Formatting** > **New Rule**.
– Choose **Use a formula to determine which cells to format**.
– Enter the following formula (assuming column `B` contains the “6 weeks date” and column `C` contains the “allocated” date):
“`excel
=AND(B1