Peo,
I think the most recent solution you sent does not work because the cells
have 3 conditions on them (within 10%, 10%-25%, over 25%) to create 3 cell
highlights. I will use the NA() to keep it simple. It results in #NA in the
cell instead of just n/a but that is fine.
Thank you so much!

"Valerie" wrote:

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