Excel: Highlight #N/A results

You can filter for all #N/A results, but can you also highlight them with conditional formatting? You have to use the ISNA function, which tests a cell for that result.

On the Home tab, Styles group, click the Conditional Formatting button, then New Rule. Select Use a formula to determine which cells to format. Type “ISNA,” then click on the first cell in the result range. When it appears in the Format values… field, remove the $ from in front of the row number. It should look something like this: =ISNA($H2). Then choose the cell formatting.