i-nth logo
Using Stop If True when Conditional Formatting
14 September 2013

When applying Conditional Formatting, you may have situations where you don't want to apply your rule to certain cells in a range.

Excel provides a clever Conditional Formatting mechanism called "Stop If True". This allows you to specify when Excel should stop evaluating/formatting values if a condition is true.

Full article: Using Stop If True when Conditional Formatting

Consulting

We can help you make better spreadsheets:

  • Reviewing your spreadsheets for errors.
  • Advice about improving your spreadsheets.
  • Training in spreadsheet good practice.

Contact us