OR

Alternatives to Conditional Formatting

Conditional Formatting, Formulas, Spreadsheet Design, Workbook performance

In my recent post of Fix duplicated Conditional Formatting Rules , I mentioned you should be careful using Conditional Formatting in situations where you have thousands of rows of data or calculations as this can be a drain on performance. I also mentioned you can use alternatives in these situations and just thought I would …

Alternatives to Conditional Formatting Read More »

Using Array Constants in Formulas – OR logic

Formulas

This is a short PS post to my earlier post on using Array Constants in Formulas basically to simplify them. The focus of the earlier post was avoiding Nested IFs but what about simplifying OR logic situations. Try… =OR(B5={“A”,”B”,”D”}) will return TRUE if B5 = A or B or D. This is a lot simpler …

Using Array Constants in Formulas – OR logic Read More »