Conditional Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WarrinerBen - 18 Aug 2006 20:22 GMT

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

Reply to this Message

oldchippy - 18 Aug 2006 20:33 GMT

WarrinerBen Wrote:

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

oldchippy ;

Reply to this Message

Dave F - 18 Aug 2006 20:37 GMT

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

Signature

Brevity is the soul of wit.

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

Reply to this Message