Tip: If any cells incorporate a components that returns an error, conditional formatting isn't applied to All those cells. To deal with this, use IS functions or an IFERROR perform with your components to return a value that you simply specify (for example 0, or "N/A") in lieu of an mistake worth. Conditional formatting ordinarily will work pre