heretolearnexcel
Board Regular
- Joined
- Jan 22, 2019
- Messages
- 61
- Office Version
- 365
- Platform
- Windows
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.
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 |