I see a lot of answers but it isn't giving me exactly what I'm looking for. I have columns of about 20 companies now and about 30 rows of different wholesale products for each company making the same product, I want to find the lowest value between each company per row / product. Is it possible to create a rule that finds the lowest value of each row and then highlights that row?
Thanks
MacBook Pro 15″, macOS 10.14
Does this resemble your table?
Companies are listed across the first row.
Products are listed down the first column.
Each row contains the various companies' price for a given item.
Columns AB and AC have been added to the base table.
These columns contain two formulas that return the MINimum and MAXimum values in the row containing the formula.
AB2: MIN(B2:AA2)
AC2: MAX(B2:AA2)
The selected cells (B2:AA10) are assigned the two Conditional Highlighting rules shown to the right of the table.
Although the example shows each 'company' carrying all of the products, the highlighting remains the same where there are some empty cells in the table. Both MIN and MAX ignore empty cells when determining the minimum and maximum values in a range of cells.
Regards,
Barry
Can you post a screenshot?
SG
Highlight highest or lowest value in each row?
