I have a Data Table, at times there will be duplicate values. I want to conditionally format a specific value defined by the horizontal and vertical heading values. Example
<tbody>
</tbody>
I enter the horizontal and vertical coordinates.
Horizontal row heading value = 22 (cell O51)
Vertical column heading value = 3 (cell O52)
Using a formula similar to this I find the value at that coordinate.
=INDEX($H$57:R$84, MATCH(O51, $G$57:$G$84, 1), MATCH(O52, $H$56:$R$56, 1))
My problem is I want to conditionally format the cell with a border and color, but if I have duplicate values all three values, 4344, are formatted. In this example I want to only format the cell at the intersection of row 22 and column 3.
1 | 2 | 3 | 4 | 5 | |
20 | 31 | 32 | 33 | 34 | 35 |
21 | 42 | 4344 | 43 | 44 | 45 |
22 | 51 | 52 | 4344 | 54 | 55 |
23 | 61 | 62 | 63 | 4344 | 65 |
24 | 71 | 72 | 73 | 74 | 75 |
<tbody>
</tbody>
I enter the horizontal and vertical coordinates.
Horizontal row heading value = 22 (cell O51)
Vertical column heading value = 3 (cell O52)
Using a formula similar to this I find the value at that coordinate.
=INDEX($H$57:R$84, MATCH(O51, $G$57:$G$84, 1), MATCH(O52, $H$56:$R$56, 1))
My problem is I want to conditionally format the cell with a border and color, but if I have duplicate values all three values, 4344, are formatted. In this example I want to only format the cell at the intersection of row 22 and column 3.