Forum Discussion
Conditional Formatting each row individually
Select the entire worksheet, or just the rows in use.
The active cell should be cell A1.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula =AND(A1<>"",A1=MIN(1:1))
Click Format...
Activate the Fill tab and select a highlight color.
You can also specify a font color and/or borders.
Click OK, then click OK again.
Repeat these steps, but with the formula =AND(A1<>"",A1=MAX(1:1)) and with a different color.
As you can see in F2 / G2, if there is more than one cell with the minimum (or maximum) value in a row, all of them will be highlighted.
HansVogelaar how can you amend this so that the top 5 and bottom 5 values in each individual row are highlighted? Also, my data sheet is right to left (orientation) and the first cell with relevant data that needs to be formatted is k2, does that matter at all?
The steps should be the same, with the formulas
=AND(A1<>"",A1<=SMALL(1:1, 5))
and
=AND(A1<>"",A1>=LARGE(1:1, 5))