Compare value against the range and highlight if the largest/smallest value

[Culaff]

Hello all,

Requesting help from you guys. So basically I am doing a tool comparison and my final dashboard looks like below[TABLE="width: 500"]
<tbody>[TR]
[TD]Evalution category[/TD]
[TD]Tool 1[/TD]
[TD]Tool 2[/TD]
[TD]Tool 3[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]8[/TD]
[TD]4[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]DEF[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]XYZ[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]

So what I am thinking is a way to highlight in which categories is Tool 1 better/worse than the other tools.

Is there any macro/formula which takes the first value of Tool 1(8), and compares with the other tool values(4 & 3), if it is the largest value - highlights it green, if lowest value highlights it Red, if neither than remains as it is. This logic loops through all the values in Tool 1 column.

Appreciate any help/tips. Thanks for your time.

 

[Peter_SSs]

I presumed you would want to do the same for the other tools so for that small sample I
- Selected B2:D4
- Home ribbon tab -> Conditional Formatting -> New rule... -> Use a formula to determine which cells to format -> Format values where this formula is true: =B2=MAX($B2:$D2) -> Format... -> Fill tab & choose Green -> OK -> OK
- Follow the same process but use formula =B2=MIN($B2:$D2) for red formatting.

If that is not what you want, please provide more details.

Excel Workbook
	A	B	C	D
1	Evalution category	Tool 1	Tool 2	Tool 3
2	ABC	8	4	3
3	DEF	1	3	6
4	XYZ	5	2	5
CF Culaff

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2	1. / Formula is =B2=MIN($B2:$D2)	Abc
B2	2. / Formula is =B2=MAX($B2:$D2)	Abc