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.

"E92er" wrote:

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.....