Multiple conditions for conditional formatting

Is it possible to have conditional formatting with multiple conditions?

e.g. Column A is blank AND Column B is ‘Yes’.

yes, it is possible and is easy…

when adding a new conditional formatting rule, select the ‘Formula’ option, then enter a formula that has the value TRUE if the rule is to be applied. in that formula you can combine multiple comparisons with AND or OR operators.


1 Like