Excel for Mac 08 - Automatically Highlight High/Low Value in Each Row of Selected Columns

[19magic75]

Hello,
I have a 2,000 row/130 columns spreadsheet that amongst other data shows Total Price and Margin % for 5 marketplaces we sell on:

- Column EJ i have Marketplace 1 Price
- Column EK i have Marketplace 1 Margin %

- Column EL i have Marketplace 2 Price
- Column EM i have Marketplace 2 Margin %

- Column EN i have Marketplace 3 Price
- Column EO i have Marketplace 3 Margin %

- Column EP i have Marketplace 4 Price
- Column EQ i have Marketplace 4 Margin %

- Column ER i have Marketplace 5 Price
- Column ES i have Marketplace 5 Margin %

- Column ET i have Marketplace 6 Price
- Column EU i have Marketplace 6 Margin %

How can I (IN EACH ROW, which represents a unique product SKU) highlight the cell that has the highest Price & the Lowest Price?
I also need the same for the Margin columns.

Thank you in advance!

[19magic75]

Here is a simplified example.
How can I make the Lowest and Highest Price and Margin for each SKU get highlighted with let's say red for low and green for high?

thanks again

[19magic75]

Hey Ladies/Gents, sorry for bumping it up, but should I take it there is no such feature that would do what I was looking for?

[romperstomper]

You need Conditional Formatting (Format-Conditional Formatting) using a formula to determine the cells to format. See attached where I have implemented it for columns B, D, F and so on. You need to replicate that for the margin columns.