Formula which changes color

[the dude]

Hi guys,
I have a list of numbers in a column as a result of a calculation from
another sheet and I would like to assign a color to this number if the
number is between 20-25, another color if between 15-19, etc.
Is there a formula or a macro which allows me do that?
Thanks!
the dude

 

[Gary''s Student]

Yes. You can set-up formatting as a function of a cell's value by using
conditional formatting:

1. select a cell
2. pull-down:
Format > Conditional Formatting

But I would look at Excel Help or:

http://www.contextures.com/xlCondFormat01.html

first