Conditional Formatting
 

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.


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

Conditional Formatting
 

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 :confused:

oldchippy ;)


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

Conditional Formatting
 

IF functions can't change the color of a cell based on the value of the cell.

You'll have to write some VBA code to do what you want. See this to get
started: http://www.cpearson.com/excel/colors.htm


--
Brevity is the soul of wit.


"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.


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