Conditional formatting for multiple items

[nutnum]

Please help!!

Conditional formatting of the column as follows:

N/A = red font

Numbers = highlighted with colour of choice

Blank = white

I have done the N/A's in red front and I've done the blanks in white, but how do I highlight all of the numbers, without the N/A's also highlighting?

The column is either left blank, has N/A, or has a number in it.

 

[StephenCrump]

Welcome to the Forum!

Like this perhaps:

	A	B
1
2		1
3
4		666
5		#N/A
6
7		#N/A
8		22
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B8	Expression	=ISNUMBER(B2)	text	NO

But if there are only three choices, and you've conditionally formatted two of them, you could also just apply this as a format.