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.
