Suggestion: If any cells contain a formula that returns an mistake, conditional formatting just isn't placed on Those people cells. To address this, use IS features or an IFERROR perform in your formulation to return a price that you specify (like 0, or "N/A") in place of an error benefit. https://data65329.wikififfi.com/967181/facts_about_data_revealed