View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
the dude
 
Posts: n/a
Default 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