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

R

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
 
J

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
 
F

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
 
M

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
 
R

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
 
Top