Excel: Highlight #N/A results — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily
  • LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Excel: Highlight #N/A results

Get PDF file

by on
in Excel Training,Office Technology

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.

Leave a Comment

Previous post:

Next post: