Tip: If any cells include a formula that returns an mistake, conditional formatting is just not placed on People cells. To handle this, use IS functions or an IFERROR purpose inside your method to return a price that you choose to specify (for example 0, or "N/A") instead of an mistake benefit. Make and format tables Resize a desk by adding or