Excel formatting formula if multiple conditions

#Excel formatting formula if multiple conditions how to#
#Excel formatting formula if multiple conditions code#

Some of the references are Absolute, and one is Relative:

Does the data entry cell (D5) match the condition entered in cell F2Д¬ell D5 is used in the formula, because that was the active cell when the conditional formatting was applied.

Does cell B2 match the condition entered in cell E2.

The AND function checks the 2 conditions: The conditional formatting formula is: =AND($B$2=$E$2,D5=$F$2)

Click OK, to apply the conditional formattingД«ecause вЂњUSвЂќ is entered in cell B2, any cell in D5:D14 that contains вЂњUnited StatesвЂќ is coloured red.

Select red as the fill colour, and click OK.

Click Use a Formula to Determine Which Cells to Format.

On the RibbonвЂ™s Home tab, click Conditional Formatting, then click New Rule.

Select cells D5:D14, where the country names are listed for the orders.

WeвЂ™ll use the AND function, to check both conditions, and the formula is explained in the next section. The next step is to add conditional formatting to the country cells in the data range D5:D14.

#Excel formatting formula if multiple conditions code#

People will type a country code in cell B2, so I filled that cell with yellow, to make it stand out. You could also name the cells, and use those names in the conditional formatting formula. You could put them on a different sheet, if you prefer, to prevent people from accidentally changing them. In this workbook, the conditions are in cells E2 and F2, on the same sheet as the data entry cells. However, I like to put the conditions in worksheet cells instead, so itвЂ™s easy to see them, and change the conditions later, if you need to.

In that formula, you could hard-code the вЂњUSвЂќ and вЂњUnited StatesвЂќ conditions. WeвЂ™ll need to set up a special rule for this, using a formula. There isnвЂ™t a built-in conditional formatting rule that will do this. HereвЂ™s what the worksheet looks like, after that conditional formatting is set up in cells D5:D14

The data entry cell contains вЂњUnited StatesвЂќ.

The country code вЂњUSвЂќ is entered in cell B2.

The person who sent the question wanted to highlight cells based on 2 conditions:

#Excel formatting formula if multiple conditions how to#

Unless you were using the computer as excuse to hide away from all the holiday chaos! Now weвЂ™re back to work, and one of the first questions I got this year was how to highlight cells based on two conditions. Happy New Year! I hope you had time to relax over the holidays, and you stepped away from the computer for a while.