Conditional Formatting

[Phil]

HI,

When using the following formula if(a1=0,na(),a1)the
respons na() returns #N/A.
From other postings they state conditional format this
cell to a white font.
How is this carried out?
Evey time I try it just stay black
Kind Regards
Phil

 

[Frank Kabel]

Hi
if this formula is in cell B1 try:
- select cell B1
- goto the conditional format dialog
- enter the formula
=ISNA(B1)
- choose your format

 

[Phil]

Thank you so much

-----Original Message-----
Hi
if this formula is in cell B1 try:
- select cell B1
- goto the conditional format dialog
- enter the formula
=ISNA(B1)
- choose your format

--
Regards
Frank Kabel
Frankfurt, Germany



.

 

[Cutter]

In the cell containing your formula (A2 in my example) do conditiona
format with Formula is
then type the formula =ISNA(A2)
set your font format to white then OK, O

 

[Cutter]

In the cell containing your formula (A2 in my example) do conditiona
format with Formula is
then type the formula =ISNA(A2)
set your font format to white then OK, OK


but why wouldn't you just have the formula
=if(a1=0,"",a1)
and forget about conditional formattin