Conditional Formatting

[WarrinerBen]

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

 

[oldchippy]

Looking for a solution to a conditional format problem. I need t
change the color of a cell based on the input, with 8 different option
matching 8 different colors. Conditional format only has thre
parameters, so I can't use this option. Thought about using a neste
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/newsgroups/worksheet_as_chart/index.htm

Let me know if this is what you are looking for

oldchippy ;

 

[Dave F]

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