#N/A Can a conditional format change this to a white font?

[RudeRam]

#N/A Can a conditional format change this to a white font?

Since I have cell B7 Linked from another worksheet and I have trie
=B7 format White and nothing happens

Am I missing something here

 

[JulieD]

Hi

you could embed your current formula in an IF(ISNA( structure to "deal" with
the #N/A error

e.g.
=IF(ISNA(your original formula),"",your original formula again)

Cheers
JulieD

 

[Frank Kabel]

Hi
lets assume this value is in cell D2: select this cell, goto 'format -
Conditional Format' and enter the following formula
=ISNA(D2)
- choose a white font.

Note: It does not help if you format the source cell as a 'link' only
'copies' the value but not the formats of the source cell

 

[Max]

#N/A Can a conditional format change this to a white font?

Try as the cond format setting for B7:
Condition 1:
Formula Is |=ISNA(B7)
Format > Font > White

 

[RudeRam]

Frank,

Thank you your suggestion worked awsome. To Julie and Max Thank yo
also. As I have shared my worksheet with others I need to keep th
formatting to the simpliest of terms.

Again thank you all

Rud

 

[Max]

You're welcome !