In conditional formatting for the cell you want to ( hide NA ) - FORMULA IS
=ISERROR(Cell#) then press the format button and format cell color as white

"Lele" wrote:

I have pre-populated a spreadsheet to be used as an order form with
v-lookups. Until the user enters an item the #N/A text appears. Is there a
simple way I can use conditional formatting to make the #N/A font color white
so it will appear invisible until a line item is entered at which time I
would change font color back to black?

Also, I would like to show a sums at the bottom of the spreadsheet, but
since I don't know how many items the customer will order I don't know the
number of rows to include

Thanks so much
--
Lele