Forum Discussion
Help on how to highlight the lowest cell in every row.
Select the data rows from B2:J2 down.
B2 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=B2=MIN($B2:$J2)
(Please note that there are $ signs before the column letters in $B2:$J2 but not before the row number 2)
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
Select the data rows from B2:J2 down.
B2 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=B2=MIN($B2:$J2)
(Please note that there are $ signs before the column letters in $B2:$J2 but not before the row number 2)
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
- This is brilliant! I tried the formula thing but couldn't figure out the right one. Also, your instructions are amazing! I wish everyone would answer them as descriptively as you do.
You're welcome. Thank you for your kind words, much appreciated!
