Color codings of data

[Ranny Robertson]

Is there a method to apply a color automatically to a
column of numbers? By that I mean I'd like to take a column
of numbers and have all say under 50 to be black, between
50 and 100 to be yellow and over 100 to be red. Is that
possible and if so, how?
Thanks,
Ranny

 

[Paul B]

Ranny, go to format and then conditional formatting, this should do what
you need

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[CLR]

Highlight the cells you want to affect.......
Format > Conditional format.......
Condition 1
Cell Value is > Greater than > 100 > format > Font > Color: > select Red
square > ok
Add >
Condition 2
Cell Value is > between > 50 > 100 > format > Font > Color: > select Yellow
square> ok > ok

Vaya con Dios,
Chuck, CABGx3