Hi All,
I have a set of data. I want to use conditional formatting to make all the #N/A values to disappear. I only want the numbers. How can I accomplish this? Here is one row as an example.
46831.20
79066.80
89878.60
#N/A
75763.64
#N/A
46201.80
73854.00
45319.80
#N/A
#N/A
47334.75
184447.72
#N/A
366962.31
49380.30
#N/A
67712.40
51527.90
#N/A
#N/A
#N/A
Last edited by JulieChu; 05-06-2010 at 11:24 AM.
Go to format|Conditional Formatting
Cell Value Is >> Equal to >> #N/A
Click Format and from Font tab, choose colour that matches your cell background.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi
are teh errors the result of a formula ? If so try =if(iserror(your_formula),"",your_formula)
@ NBVC:Originally Posted by NBVC
I've tried that, it doesn't work
@arthurbr
The values are numbers, there are no formulas. I paste specialed only the numbers from a data dump.
Thx
Formula is missing an = sign and quotes... don't know what I was thinkin'
should be Cell Value Is >> Equal To >> ="#N/A"
For data in column A select the column and use conditional formatting with formula is option and the formula
=ISNA(A1)
and set format to white font
Ok... I should go hide under my shell... I really don't know what I am thinking todayFor data in column A select the column and use conditional formatting with formula is option and the formula
=ISNA(A1)
and set format to white font
Edit: I think I know what I was dreaming... i guess if it works for counting like this: =COUNTIF(I2:I4,"#n/a") then it would work for conditional formatting "#n/a")...I was wrong...
Last edited by NBVC; 05-06-2010 at 10:54 AM.
That works only for cell A1
I've tried selecting the entire column in the source as well i.e.
=ISNA($G$6:$G$20)
That doesn't work either.
Select the range: G6:G20 and then invoke CF,
but enter only =ISNA(G6)
this will auto update relatively in your range.
THAT WORKS!
AWESOME WORK GUYS!
Thanks,
-Julie
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks