WarrinerBen Wrote:
Looking for a solution to a conditional format problem. I need to
change the color of a cell based on the input, with 8 different options
matching 8 different colors. Conditional format only has three
parameters, so I can't use this option. Thought about using a nested
if, but do not know the designator to change cell color.
Hi WarrinerBen,

Take a look at this link it may help with your solution

http://tushar-mehta.com/excel/newsgr...hart/index.htm

Let me know if this is what you are looking for

oldchippy ;)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=573232