Conditional Formatting - 2 conditions
 

Excel 2003
The cell to conditionally format is a reference name. The reference name
will not always be valid
I would like to format on 2 conditions, one as an error (to format as blank)
when the reference name does not exist, and second to format without the
error.
I am successful on the first condition with the following:
Formula Is =ISERROR(#NAME?) with font color of white
I can not get the second condition to work. Nothing I have tried overrides
the first condition. (The referenced name is valid, but formatting does not
change.)
Any suggestions on what the second condition would like?
--
Appreciate your help!

Conditional Formatting - 2 conditions
 

Assuming you are trying to highlight cell A1
=ISERROR(#NAME?)
is always true hence your second condition is not being evaluated
use
=ISERROR(A1)
it will be true if A1 has #NAME? error, false otherwise

"LorrieM" wrote:

Excel 2003
The cell to conditionally format is a reference name. The reference name
will not always be valid
I would like to format on 2 conditions, one as an error (to format as blank)
when the reference name does not exist, and second to format without the
error.
I am successful on the first condition with the following:
Formula Is =ISERROR(#NAME?) with font color of white
I can not get the second condition to work. Nothing I have tried overrides
the first condition. (The referenced name is valid, but formatting does not
change.)
Any suggestions on what the second condition would like?
--
Appreciate your help!

Conditional Formatting - 2 conditions
 

Worked Great - Thanks
--
Appreciate your help!


"Sheeloo" wrote:

Assuming you are trying to highlight cell A1
=ISERROR(#NAME?)
is always true hence your second condition is not being evaluated
use
=ISERROR(A1)
it will be true if A1 has #NAME? error, false otherwise

"LorrieM" wrote:

Excel 2003
The cell to conditionally format is a reference name. The reference name
will not always be valid
I would like to format on 2 conditions, one as an error (to format as blank)
when the reference name does not exist, and second to format without the
error.
I am successful on the first condition with the following:
Formula Is =ISERROR(#NAME?) with font color of white
I can not get the second condition to work. Nothing I have tried overrides
the first condition. (The referenced name is valid, but formatting does not
change.)
Any suggestions on what the second condition would like?
--
Appreciate your help!