Formula which changes color
 

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

Formula which changes color
 

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