Conditional Formatting - Lowest/Highest Value in Row/Column

B

Brian

Howdy All,

I'm inputting data into a spreadsheet and I would like certain specs to
highlight according to their rank relative to other data in the same row or
column.

Example:

Row 5 = Price:

A5 = $10.00
B5 = $12.40
C5 = $11.99

I would like to format this row so that A5 will highlight because it is the
lowest price.

Thanks,
Brian
 
M

Max

Select row5 (with A5 active),
use as the conditional format formula:
=AND(A5=MIN(5:5),A5<>"")
 
Top