Forum Discussion
Highlight the minimum value in each row
Hi. I'm a complete beginner to Excel and need some help please. I'm doing a spreadsheet comparing prices from different companies for hundreds of products so I'll have about 10 columns and up to 1000...
Dear Kim,
Do the following steps as below screenshot:
1- Highlight the entire first column then go to Home >> Styles >> Conditional Formatting >> Top/Bottom Rules >> Bottom 10 Items...
2- Make the items just 1 item.
3- Select the format that you want, then hit OK.
4- Do the same thing on each column.
