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.
max