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...
- select the first cell in the first row, e.g. Cell A1
- Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format
- type the following formula, where $C is the last column
=A1=MIN($A1:$C1)
- click Format button and apply the format you want
- click OK button (format cell dialog box)
- click OK button(New Formatting Rule dialog box)
- Home > Conditional Formatting > Manage Rules
- You can see your rule, and which cells that it applies to
- You can change the value in Applies to to apply on all rows.
Can i ask you where someone who is novice in excel, to find such formulas and other useful tips? Thank you for your responseWilly Lau
