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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

E92er - 06 Feb 2008 23:46 GMT

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

Reply to this Message

Jules - 07 Feb 2008 00:37 GMT

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.

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

Reply to this Message