Conditional formatting greatest value in each row of multiple columns, that ignores text/empty cells/0 values

[heretolearnexcel]

Hello,

I'm trying to use conditional formatting to highlight the smallest value in each row, but there are some cells with text values that are getting highlighted. I'm currently using this formula:
=D2=MIN($D2:$Z2)

applies to: =$D:$Z

What could be an efficient formula to ignore those cells?

Thanks in advance.

gallina_feliz_comparativo.xlsx
	D	E	F	G	H	I	J
1	a	b	c	d
2	$1,077.58	N/D	N/D	N/D
3	$58.00	N/D	53	64
4	$70.00	60	N/D	86
5	$180.00	135	150	166
6	$200.00	159	175	194
7	$31.00	N/D	26.5	N/D
8	$35.00	N/D	N/D	N/D
9	$50.00	N/D	44	54
10	$485.00	N/D	N/D	N/D
11	$90.00	N/D	N/D	N/D
12	$110.00	118	105	119
13	$120.00	N/D	N/D	N/D
14	$22.00	N/D	N/D	N/D
15	$18.50	N/D	18	30
16	$34.00	N/D	N/D	N/D
17	$48.00	N/D	43	48
18	$46.30	N/D	46	N/D
19	$69.44	N/D	N/D	N/D
20	$55.00	N/D	N/D	56
21	$440.00	N/D	370	450
22	$325.00	N/D	105	144
23	$1,300.00	N/D	N/D	N/D
24	$25.00	N/D	N/D	N/D
25	$46.58	N/D	N/D	N/D
26	$55.56	N/D	N/D	N/D
27	$21.30	N/D	N/D	N/D
28	$130.00	150	140	163
29	$75.00	82	50	86
30	$95.00	N/D	N/D	N/D
31	$90.00	85	N/D	N/D
32	$224.14	N/D	N/D	N/D
33	$75.00	N/D	N/D	N/D
34	$65.00	N/D	N/D	N/D
35	$95.00	90	83	86
36	$145.00	N/D	N/D	N/D
37	$90.00	N/D	N/D	N/D
38	$95.00	N/D	N/D	N/D
39	$24.00	N/D	N/D	N/D
40	$30.00	N/D	N/D	N/D
41	$157.41	135	100	N/D
42	$41.67	N/D	N/D	N/D
43	$26.00	N/D	N/D	N/D
44	$37.04	N/D	N/D	N/D
45	$80.00	N/D	N/D	N/D
46	$193.00	N/D	N/D	N/D
47	$79.63	N/D	N/D	N/D
48	$94.00	N/D	68	N/D
49	$38.00	N/D	N/D	N/D
50	$42.00	N/D	N/D	N/D
51	$38.00	N/D	N/D	N/D
52	$125.00	N/D	N/D	N/D
53	$310.00	N/D	N/D	N/D
54	$160.00	N/D	N/D	N/D
55	$160.00	150	115	117
56	$130.00	N/D	N/D	N/D
57	$155.00	N/D	N/D	N/D
58	$128.00	N/D	N/D	N/D
59	$28.00	N/D	28	N/D
60	$28.00	N/D	28	N/D
61	$44.00	52	44	55
62	$20.25	N/D	19	N/D
63	$203.70	170	150	264
64	$165.00	N/D	N/D	N/D
65	$100.00	N/D	N/D	N/D
66	$240.74	255	N/D	211
67	$203.70	N/D	N/D	131
68	$275.00	N/D	N/D	292
69	$90.00	N/D	N/D	N/D
70	$105.00	N/D	N/D	109
71	$14.00	N/D	N/D	N/D
72	$135.00	N/D	123	N/D
73	$140.00	N/D	N/D	N/D
74	$208.33	155	N/D	233
75	$250.00	233	240	225
76	$160.00	N/D	N/D	N/D
77	$45.00	52	50	92
78	$100.00	N/D	N/D	N/D
79	$27.00	N/D	N/D	N/D
80	$88.00	82	90	97
81	$50.00	N/D	N/D	N/D
82	$29.00	N/D	28	N/D
83	$52.00	N/D	N/D	55
84	$30.00	N/D	N/D	35
85	$50.00	N/D	47	62
86	$150.00	N/D	N/D	N/D
87	$115.00	N/D	N/D	N/D
88	$14.00	N/D	N/D	N/D
89	$44.00	46	37	54
90	$400.00	N/D	N/D	N/D
91	$148.15	155	N/D	N/D
92
93
94
95
Sheet1

Cell Formulas
Range	Formula
D2:D90	D2	=XLOOKUP(A2,cat!C:C,cat!J:J,"not found")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D:Z	Expression	=D2=MIN($D2:$Z2)	text	NO

 

[rlv01]

Possibly this:

=AND(ISNUMBER(D2),D2 =MIN($D2:$Z2))

 

[Peter_SSs]

Hint for next time: Be more careful with your wording.
Thread title: "Conditional formatting greatest value in each row"
Post #1: "conditional formatting to highlight the smallest value in each row"

 

[heretolearnexcel]

Possibly this:

=AND(ISNUMBER(D2),D2 =MIN($D2:$Z2))

Doesn't seem to work.

 

[rlv01]

Try this instead.

=AND(ISNUMBER(D1),D1=MIN($D1:$Z1))

 

[heretolearnexcel]

Try this instead.

=AND(ISNUMBER(D1),D1=MIN($D1:$Z1))

Woah, it works. Thank you. What is the logic behind why it didn't work unless you changed the rows to 1?

 

[rlv01]

Because it is the first row in your range "D:Z"

 

[Joe4]

Woah, it works. Thank you. What is the logic behind why it didn't work unless you changed the rows to 1?

Whenever you apply Conditional Formatting to a whole range of cells at once, you write the CF formula as it applies to the FIRST cell in your selection.

Since there is a header row in row 1, if your selected data range started in row 2 (where the actual data starts), then rlv01's original formula would have worked perfectly for you.
But I am guessing that maybe you selected entire columns, which means your FIRST selected cell is in row 1, not row 2.
So then your formula would have to reference row 1 instead of row 2, as shown in his second formula.