Forum Discussion
Solved
Help on how to highlight the lowest cell in every row.
Think of this as a spreadsheet with store columns and items to be purchased in rows. The design would need to have it highlight the lowest price in every row. Essentially, it would tell the user righ...
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!