#N/A

[TWIN HYPE]

Hi All,

Is there a way to use conditional formatting to hide this no value return?

#N/A

I have tried but so far have had no success.

Your guidance is always appreciated.

Thanks

Twin

 

[al_b_cnu]

Hi

One way would be to highlight the column & CF Formula is =isna(A1), with a white font

alternatively change the formulae to =if(isna(formula),"",formula)

 

[TWIN HYPE]

Morning Alan

Thanks for your reply. It doesnt seem to work on the cf dunno why! Also can you tell me why this line doesn't work:

=IF(B6 is blank,"Blank ",VALUE(B6))

I am trying to get the wording right and its turning me into a bitter, bitter man.

Thanks mate

Twin

 

[tusharm]

See Debra Dalgleish's http://www.contextures.com/xlCondFormat03.html#Errors

Hi All,

Is there a way to use conditional formatting to hide this no value return?

#N/A

I have tried but so far have had no success.

Your guidance is always appreciated.

Thanks

Twin

 

[S.H.A.D.O.]

Hi TWIN HYPE,

Try this :-
=IF(B6="","",B6)

Hope this Helps.
All the Best.
SHADO

 

[TWIN HYPE]

Sorted. You lot rock!!!!