Hi guys,
I have a list of numbers in a column as a result of a calculation fro
another sheet and I would like to assign a color to this number if th
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 dud

--
the dud
-----------------------------------------------------------------------
the dude's Profile: http://www.excelforum.com/member.php...fo&userid=3283
View this thread: http://www.excelforum.com/showthread.php?threadid=54737

Have a look at FormatConditional format

HTH
--
AP

"the dude" a écrit
dans le message de news:
...

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=547372

Search for the term "Conditional Formatting" in the Excel Help. Most likely,
it'll do the trick. You'll find teh feature on the main menu, under "Format
Conditional Formatting..."

Cheers,
/MP

"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=547372