Suggestion: If any cells incorporate a components that returns an error, conditional formatting will not be placed on Those people cells. To deal with this, use IS functions or an IFERROR functionality in the components to return a worth which you specify (including 0, or "N/A") as opposed to an mistake value. The system need to return a range,