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
--
Gary's Student
"the dude" wrote:
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
--
the dude
------------------------------------------------------------------------
the dude's Profile: http://www.excelforum.com/member.php...o&userid=32838
View this thread: http://www.excelforum.com/showthread...hreadid=547375