In the formula that returns either a number or the "n/a",
if you use a text representation of it change it to NA() instead of "N/A"
Or use formula is in the conditional formatting and use

=AND(ISNUMBER(A1),your_criteria)

if you have a text n/a in the cell it will always be greater than any number
thus greater than
25% from the target

--


Regards,


Peo Sjoblom

"Valerie" <Valerie @discussions.microsoft.com wrote in message
...
I have written a formula that may return "n/a" or a number. If it is a
number, there are 3 conditional format colors that can occur if the number
is
within 10%, etc from a specified target. If the formula brings back
"n/a",
the cell is still turning a color as if it is 25% from the target. How do
I
get the cell to have no highlight, since the value is "n/a"?
Thank you,
-Valerie