Conditional Formatting ignore specific text

[Tryingtoresolve]

I am struggling with a conditional format to work I'm trying to get one cell to change colour if higher than another I can make this work but I'm trying to get it to ignore N/A within the column I've tried using this =IF(O2>U2),"N/A) it accepts it and changes the cell where its higher Qty than U2 but still highlights N/A within the cell as well

 

[duggie33]

I think a second Conditional Formatting rule would solve this...

Book1.xlsx
	A	B
1	5	2
2	2	33
3	32	32
4	N/A	42
5	4	20
6	30	8
7	28	42
8	N/A	14
9	15	12
10	10	27
11	22	13
12	32	48
13	10	50
14	N/A	23
15	33	40
16	50	9
17	18	38
18	20	22
19	12	18
20	N/A	45
21	49	49
22	29	12
Sheet5

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1:B22	Expression	=A1="N/A"	text	YES
B1:B22	Expression	=A1>B1	text	NO

Hope that helps,

Doug

 

[dreid1011]

It could be achieved with a single rule:

=AND(O2>U2,O2<>"N/A")

Change the references to suit your data.