cell color

[flyingmeatball]

I have 3 columns of cells that have numbers between 1-100 (these are
percentiles). I need all cells 1-25 to be colored blue, 26-75 colored
yellow, and 76-100 colored red. Is there a way I can make these cells
automatically change color, or is this possible to do with a macro?
Thanks

Karl

 

[jonhunt]

You can do this with Conditional Formatting. Select your range of cells
Go to Format. Select Conditional Format. You can then enter th
conditions under which a cell would turn which color

 

[jonhunt]

Once you put in the conditions, click on format and you can select th
color. Then you can set a second or third condition and selec
different colors for different variables

 

[Bob Phillips]

Use Conditional Formatting with conditions of less than 26 blue, less than
76 yellow, and less than equal 100 to red.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"flyingmeatball"