Conditional Formatting without 'Fill'

I've created a table and in that table is a column that has a data validation list for users to select from. I didn't want an error message to pop up if someone typed something different in because there are custom cases, but I did want the text to be red if they were to type something different than my list's range.

I simply went to conditional format and set [Formatting is true when cell value <> Range]. And so when I put in a value not within my defined range, the text is red. The only problem is so is the fill of the cell. My table has alternating colored lines (white and gray) and I'd like to maintain that by the conditional formatting only changing the text color and nothing else.

Any tips?
Thanks!

*************************************

SOLVED:

Originally Posted by Ace_XL

I changed the formula to
=NOT(ISNUMBER(MATCH(F6,PrimaryVendor,0))) to find exact matches

The formula now checks for an exact 'Match' based on the input in the active cell (F6 in your first case) with your 'PrimaryVendor' list . Note the relative reference to F6, this will change to F7, F8 and so on for the next rows. If it finds a match it will return a number which will be identified as a TRUE by the ISNUMBER function, the NOT at the beginning will convert this TRUE to a FALSE and the condition will not be met, thereby not changing the format of the cell.

However, if it does not find a match, the ISNUMBER function will return a FALSE which will then be converted to a TRUE and the format will change.

It does not work on a random basis as the format will change only for values that are not found in your PrimaryVendor list.

Hope this helps! See attached.

This solved my fill issue as well. Thanks for the tips guys - I appreciate it.