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.
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.