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