PDA

View Full Version : Using colors to show numbers



Tenspeed39355
03-20-2006, 07:24 PM
Hi guys Another question for you. In column B I have numbers that
represent the lows of some numbers in columns D:IV. I have the cell location. Is there a way to show the low number in columns D:IV in some
color.
Example In column B the number is 10. In columns D:IV the numbers run
from 5 to 100 with the low number being 10. How can I show the low number in any color. If the low number for some reason changes cell the color will follow. Thanks for your time with this problem
Max

Jacob Hilderbrand
03-20-2006, 08:17 PM
Use Conditional Formatting.

i.e.

Formula Is: D1 = Min($D1:$IV1)

Tenspeed39355
03-21-2006, 05:54 AM
For some reason I can not get the formula above to work. Here is what I have done, In B1 I have the min number 10. In D1:IV1 I have the numbers
5,9, 10. I opened conditional formatting changed to Equal to. I then entered the formula D1=MIN($D1:$IV1) and set the color to green.
Nothing happened. The number 10 in D1:IV1 did not change to green.
What am I doing wrong? Thanks
Max

austenr
03-21-2006, 10:47 AM
In Conditional Formatting instead of "Equal To" make it "Formula Is"

Cyberdude
03-21-2006, 04:09 PM
You might post the condition formulas that you are using. A formula that works on a spreadsheet doesn't always work in the conditional formatting for some reason. At times I have trouble with using "AND" and "OR", for example. Let us see what you have.