Formula to higlight highest and lowest values in row

G

Guest

I have a spreadsheet in Excel 2003 that shows different suppliers in the
columns, and different items in the rows. I need to find a formula that will
find the highest value for each item, and highlight it in green, and find the
lowest value for each item and highlight in red. Is this possible?
 
D

Don Guillett

highlight the range or the column header>format>conditional format>formula
is>=f1=max(f:f)>format as desired
 
G

Guest

Thanks Don,
I can find the max value in each row by entering a conditional format
formula of =E7=MAX(E7:I7), but when I try to add another formula
=e7=min(e7:I7) it doesn't work properly - some rows end up with two cells
highlighted green. Any ideas?
 

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

Trying to find additional ranges outside of min, max, and average 2
Formula Needed for lowest three values in a Column 12
conditional format question - I think... 3
MIN will not find lowest of calculated values How? 5
Trying to subtract the two lowest values from a row of numbers 4
Average of values in row excluding the highest and lowest value? 18
Scores of a Range Cells. Highest or lowest depending a parameter 1
Find 2 highest point to form resistance line 5

Top