Hi
I have a bit of a challenging conundrum (for me at least!). Id like a conditional formatting rule to highlight the three closes numbers across the three columns, but with only 1 cell highlighted per column.
So if my data was as follows, the closest 3 would be the ones in bold. (1 per column)
[TABLE="width: 500"]
<tbody>[TR]
[TD]211.05
[/TD]
[TD]213.32
[/TD]
[TD]199.08
[/TD]
[/TR]
[TR]
[TD]209.37
[/TD]
[TD]212.35
[/TD]
[TD]198.11
[/TD]
[/TR]
[TR]
[TD]207.69
[/TD]
[TD]211.37
[/TD]
[TD]197.13
[/TD]
[/TR]
[TR]
[TD]205.25
[/TD]
[TD]209.95
[/TD]
[TD]195.71
[/TD]
[/TR]
[TR]
[TD]203.87
[/TD]
[TD]209.15
[/TD]
[TD]194.91
[/TD]
[/TR]
[TR]
[TD]202.25
[/TD]
[TD]208.2
[/TD]
[TD]193.96
[/TD]
[/TR]
[TR]
[TD]198.38
[/TD]
[TD]205.95
[/TD]
[TD]191.71
[/TD]
[/TR]
[TR]
[TD]193.45
[/TD]
[TD]203.08
[/TD]
[TD]188.84
[/TD]
[/TR]
[TR]
[TD]179.21
[/TD]
[TD]194.79
[/TD]
[TD]180.55
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have a bit of a challenging conundrum (for me at least!). Id like a conditional formatting rule to highlight the three closes numbers across the three columns, but with only 1 cell highlighted per column.
So if my data was as follows, the closest 3 would be the ones in bold. (1 per column)
[TABLE="width: 500"]
<tbody>[TR]
[TD]211.05
[/TD]
[TD]213.32
[/TD]
[TD]199.08
[/TD]
[/TR]
[TR]
[TD]209.37
[/TD]
[TD]212.35
[/TD]
[TD]198.11
[/TD]
[/TR]
[TR]
[TD]207.69
[/TD]
[TD]211.37
[/TD]
[TD]197.13
[/TD]
[/TR]
[TR]
[TD]205.25
[/TD]
[TD]209.95
[/TD]
[TD]195.71
[/TD]
[/TR]
[TR]
[TD]203.87
[/TD]
[TD]209.15
[/TD]
[TD]194.91
[/TD]
[/TR]
[TR]
[TD]202.25
[/TD]
[TD]208.2
[/TD]
[TD]193.96
[/TD]
[/TR]
[TR]
[TD]198.38
[/TD]
[TD]205.95
[/TD]
[TD]191.71
[/TD]
[/TR]
[TR]
[TD]193.45
[/TD]
[TD]203.08
[/TD]
[TD]188.84
[/TD]
[/TR]
[TR]
[TD]179.21
[/TD]
[TD]194.79
[/TD]
[TD]180.55
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]