Tip: Other languages are Google-Translated. You can visit the English version of this link.
or

Register

or
0
0
0
s2smodern

## How to conditional format cells if containing #N/A in Excel?

With the conditional formatting function, you can quickly format all cells which containing #N/A in Excel. This tutorial will show you how to achieve it in details.

Conditional format cells containing #N/A in Excel

You may interested in:

### Combine multiple worksheets/workbooks into one worksheet / workbook:

Combine multiple worksheets or workbooks into one single worksheet or workbook may be a huge task in your daily work. But, if you have Kutools for Excel, its powerful utility – Combine can help you quickly combine multiple worksheets, workbooks into one worksheet or workbook.

Kutools for Excel includes more than 120 handy Excel tools. Free to try with no limitation in 60 days. Read More      Download the free trial now

#### Conditional format cells containing #N/A in Excel

###### Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

Please do as follows to format cells which containing #N/A with conditional formatting function.

1. Select the range which contains the #N/A cells you want to format.

2. Then click Conditional Formatting > New Rule under Home tab. See screenshot:

3. In the New Formatting Rule dialog box, please do as follows.

1). Select Use a formula to determine which cells to format in the Select a Rule Type box;

2). Copy and type formula =ISNA(A1) into the Format values where this formula is true box;

Note: A1 in the formula is the beginning cell of my selected cell range, you need to change it to meet your selection. If your selected range is A2:D10, the A1 should be changed to A2 in the formula.

3). Click the Format button. See screenshot:

4. In the Format Cells dialog box, specify format for the #N/A cells, and then click the OK button.

5. When it returns to the New Formatting Rule dialog box, click the OK button.

You can see all cells which contain #N/A are formatted with the format you specified above.

### Replace #N/A error value or all error values with zero, custom message or cell reference

Kutools for Excel's Error Condition Wizard utility can quickly add error condition to a formula or group of formulas to display the formulas that produce errors with the 0(zero), a custom message, blank cells, cell reference, etc.

Kutools for Excel includes more than 120 handy Excel tools. Free to try with no limitation in 60 days. Read More      Download the free trial now

### Recommended Productivity Tools

#### Office Tab

Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

#### Kutools for Excel

Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

200 New Features for Excel, Make Excel Much Easy and Powerful:

• Merge Cell/Rows/Columns without Losing Data.
• Combine and Consolidate Multiple Sheets and Workbooks.
• Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
• Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,