Conditional Formatting - Lowest/Highest Value in Row/Column

  • Thread starter Thread starter Brian
  • Start date Start date
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
 
Select row5 (with A5 active),
use as the conditional format formula:
=AND(A5=MIN(5:5),A5<>"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional format Column based on Week Date 2
Highlight highest value in row 7
Hide Rows and Columns based on Date Input 6
Counting columns of data that has been conditionally formatted 5
Conditional Formating: MAX & MIN 3
COPY conditional formatting 0
How to vary shading of groups of rows, based on change in value in aparticular column 9
conditional formatting & formula 4

Back
Top