Conditional Formatting
 

Hello,

I have an issue with conditional formatting. I have the below formulas
assigned to their respective colors (Green, Yellow and Red) to highlight
quickly what categories I'm pulling numbers for are either; okay (green) and
need attention (red) ... Anyway, I'm looking at each category by site level
(I work for a Petroleum company) and each site numbers is a gas station in my
system ... however, for some reason my conditional formatting is
high-lighting (yellow) anything that I make as a "N/A" ... regardless if I
input it as "iserror" formula or manually type in "N/A" --- why is the
conditional format making "N/A" yellow and in some other issues for a
separate category items not filling in the color at all? Please help. Thanks.

=AND(ISNUMBER(I14),I14=I$7) (Green color)
=AND(ISNUMBER(I14),I14=I$6) (Yellow color)
=AND(ISNUMBER(I14),I14<I$6) (Red color)