Using Conditional Formatting to draw attention to cells that are blank

displays a particular color based on the relative value of the cell contents to other selected cells.

helps locate errors in cells quickly.

helps locate where data may be missing.

displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range.