| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionally formatting cells with "#N/A" as value
I want all cells with a value of "#N/A" to show up as shaded and I can't get
any result. I am using cell value is equal to "#N/A" and nothing! I am using Excel 2003. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditionally formatting cells with "#N/A" as value
There is a distinction between the text string "#N/A" and the error code
NA() -- David Biddulph "Jen O.P." wrote in message ... I want all cells with a value of "#N/A" to show up as shaded and I can't get any result. I am using cell value is equal to "#N/A" and nothing! I am using Excel 2003. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditionally formatting cells with "#N/A" as value
Hi,
Select thos cells and assuming A1 is at the top of the range use the conditional format formula =isna(a1) Mike "Jen O.P." wrote: I want all cells with a value of "#N/A" to show up as shaded and I can't get any result. I am using cell value is equal to "#N/A" and nothing! I am using Excel 2003. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Diff. change headline in "Formatting" or "Outlining" toolbar? | Excel Discussion (Misc queries) | |||
| Excel 2003: Conditional Formatting using "MIN" & "MAX" function | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
| Conditionally Hide Validation "Input Message" | Excel Discussion (Misc queries) | |||
Linear Mode
