| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting a #N/A return in a cell? I want it white.
I would like to format the '#N/A' results (from a VLookup) in a column to be
white or invisible, but because it is neither a value or a formula, I am having trouble. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting a #N/A return in a cell? I want it white.
Why not do this instead?
=IF(ISNA(VLOOKUPHERE),"",VLOOKUP) That way, if it's #N/A, then it shows nothing in the cell. ************ Hope it helps! Anne Troy www.OfficeArticles.com "Wendy" wrote in message ... I would like to format the '#N/A' results (from a VLookup) in a column to be white or invisible, but because it is neither a value or a formula, I am having trouble. Any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting a #N/A return in a cell? I want it white.
But to answer your question, use: If A1 is the cell you want to Conditionally Format Under Formula is =ISNA(A1) -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=505813 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| BULK Conditional Formatting - by column without going into each cell? | Excel Discussion (Misc queries) | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting if any value in the cell | Excel Worksheet Functions | |||
| Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
