Forum Discussion
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 right away which stores to purchase said items.
The Structure
- A1 is the Item header.
- A2 would be a named item.
- B1 through J1 are store name headers.
- B2 through J2 are prices for named stores.
- This would be formatted as a table.
Does anyone have any idea how to do this? I tried looking at Conditional Formatting but I don't see an option there. I thought the Top/Bottom Rule would do it but I can't figure out how.
Any help is very much appreciated.
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.
3 Replies
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!
