Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting #n/a
I had a spreadsheet sent to me that has the text #n/a in some of the cells.
Want to to a conditional formatting to highlight any cell that contains the text #n/a but it is not working. Does anyone know why? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting #n/a
The #N/A isn't a text, it's an error value. Use the IsError() function in your conditional format (where the cell whose value you are testing goes inside the parentheses) and it should work. -- jamescox ------------------------------------------------------------------------ jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113078 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting #n/a
It's most likely the NA error, as opposed to just n/a. Try changing your
conditional formula to something similar to this: =A1=NA() -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Supe" wrote: I had a spreadsheet sent to me that has the text #n/a in some of the cells. Want to to a conditional formatting to highlight any cell that contains the text #n/a but it is not working. Does anyone know why? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting #n/a
As a follow up to the reply by jamescox, you could use a formula such as
=ISNA(A1) in your conditional formatting. Note when you type =NA() into a cell, what you see is #N/A but as jamescox points out this is not text but an error value best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Supe" wrote in message ... I had a spreadsheet sent to me that has the text #n/a in some of the cells. Want to to a conditional formatting to highlight any cell that contains the text #n/a but it is not working. Does anyone know why? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |