- Can you do conditional formatting with 2 conditions?
- Can you have more than 3 conditional formats in Excel?
Can you do conditional formatting with 2 conditions?
Conditional Formatting With Multiple Conditions
To highlight cells according to multiple conditions being met, you can use the IF and AND Functions within a conditional formatting rule. Select the range you want to apply formatting to. In the Ribbon, select Home > Conditional Formatting > New Rule.
Can you have more than 3 conditional formats in Excel?
You can apply multiple conditional formats to the same cells.