Formula for changing cell format based on more than 3 values
 

Hello,

I was wondering how could it be possible to change the format (color to be
exact) of a cell based one of 5 possible values (for example: 1=red; 2=pink
or magenta; 3=orange; 4=yellow, 5=light cyan). Conditional formatting only
does this for three possibilities.

Thanks,

Francisco Rodriguez

Formula for changing cell format based on more than 3 values
 

You could upgrade to XL2007, which will give you a lot more CFs in one
cell, or you could download a free addin (CFPlus) from Bob Phillips
available he

http://www.xldynamic.com/source/xld.....Download.html

and this will give you up to 30 CFs in a cell.

Hope this helps.

Pete

On Feb 11, 7:08*pm, Francisco Rodriguez
wrote:
Hello,

I was wondering how could it be possible to change the format (color to be
exact) of a cell based one of 5 possible values (for example: 1=red; 2=pink
or magenta; 3=orange; 4=yellow, 5=light cyan). Conditional formatting only
does this for three possibilities.

Thanks,

Francisco Rodriguez

Formula for changing cell format based on more than 3 values
 

The link does not show any files. It says it has been moved or deleted but
the link is no longer working....

Any other ideas?

Francisco

"Pete_UK" wrote:

You could upgrade to XL2007, which will give you a lot more CFs in one
cell, or you could download a free addin (CFPlus) from Bob Phillips
available he

http://www.xldynamic.com/source/xld.....Download.html

and this will give you up to 30 CFs in a cell.

Hope this helps.

Pete

On Feb 11, 7:08 pm, Francisco Rodriguez
wrote:
Hello,

I was wondering how could it be possible to change the format (color to be
exact) of a cell based one of 5 possible values (for example: 1=red; 2=pink
or magenta; 3=orange; 4=yellow, 5=light cyan). Conditional formatting only
does this for three possibilities.

Thanks,

Francisco Rodriguez

.

Formula for changing cell format based on more than 3 values
 

John McGimpsey shows a technique he

http://www.mcgimpsey.com/excel/conditional6.html

which effectively allows you to set up 6 conditional formats in a
cell, with no code. Essentially, Custom formatting is used to give you
3 colours and the other 3 colours can be obtained through Conditional
Formatting.

Hope this helps.

Pete

On Feb 12, 2:38*pm, Francisco Rodriguez
wrote:
The link does not show any files. It says it has been moved or deleted but
the link is no longer working....

Any other ideas?

Francisco



"Pete_UK" wrote:
You could upgrade to XL2007, which will give you a lot more CFs in one
cell, or you could download a free addin (CFPlus) from Bob Phillips
available he

http://www.xldynamic.com/source/xld.....Download.html

and this will give you up to 30 CFs in a cell.

Hope this helps.

Pete

On Feb 11, 7:08 pm, Francisco Rodriguez
wrote:
Hello,

I was wondering how could it be possible to change the format (color to be
exact) of a cell based one of 5 possible values (for example: 1=red; 2=pink
or magenta; 3=orange; 4=yellow, 5=light cyan). Conditional formatting only
does this for three possibilities.

Thanks,

Francisco Rodriguez

.- Hide quoted text -

- Show quoted text -