How do I get Excel to make highest #, 1 color, & lowest # another?

E

E92er

How do I get Excel to automatically make the highest value in a given row to
be one color, and the lowest value to be another? For example....I enter in
daily prices for certain products. After ~7 days, I want the highest price
for that product during the week to be red, and the lowest price paid to be
green.....
 
J

Jules

Under Format > Conditional Formatting, you can set up the conditions for
display in the color or font you choose, and if you need to add a condition,
click the Add button at the bottom of the dialog.
 

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

High and Low values in column 2
Excel Forms Spin Button - Return to 1 after max value 0
How do I get the lowest number in a row to turn red in Excel ? 5
Trying to find additional ranges outside of min, max, and average 2
Formula to higlight highest and lowest values in row 4
How do I make the smallest number in a column red ( No VBA Please ) 11
Steam user spends $13,000 to get to Steam's highest level 2
How do I record new Highest / Lowest numbers as data changes in ce 2

Top