Conditional Formatting - Code to colour 3+ text values differently

Hi,
In my spreadsheet I would like to highlight 3+ text values in bold and
different colours. E.g. New = green/bold, Modify =blue/bold, Delete =
red/bold, Undecided = yellow/bold.

Conditional formatting only allows you to add 3 conditions. Can someone
provide some code so I can add more than 3 conditions. I would like to apply
the code to the whole spreadsheet (not just a range of cells). Thanks

There are actually 4 conditions if you count the default color.

You have 4 conditions in your example.

Format "New" cells with green/bold then use the 3 CF conditions for the other 3
words.

I'm not sure I would apply to the entire worksheet.

Would you ever use that many cells?

If you have more than 4 conditions you can use event code for multiple
conditions or use Bob Phillips' CFPlus add-in which allows for 30 CF

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


Gord Dibben MS Excel MVP

On Thu, 22 Nov 2007 17:52:00 -0800, AK9955
wrote:

Hi,
In my spreadsheet I would like to highlight 3+ text values in bold and
different colours. E.g. New = green/bold, Modify =blue/bold, Delete =
red/bold, Undecided = yellow/bold.

Conditional formatting only allows you to add 3 conditions. Can someone
provide some code so I can add more than 3 conditions. I would like to apply
the code to the whole spreadsheet (not just a range of cells). Thanks

I need a copy of excel cfplus addin.
I can't get it from Bob Phillips web site.the link seems to be broken



Gord Dibben wrote:

There are actually 4 conditions if you count the default color.
22-Nov-07

There are actually 4 conditions if you count the default color.

You have 4 conditions in your example.

Format "New" cells with green/bold then use the 3 CF conditions for the other 3
words.

I'm not sure I would apply to the entire worksheet.

Would you ever use that many cells?

If you have more than 4 conditions you can use event code for multiple
conditions or use Bob Phillips' CFPlus add-in which allows for 30 CF

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


Gord Dibben MS Excel MVP

On Thu, 22 Nov 2007 17:52:00 -0800, AK9955
wrote:

Previous Posts In This Thread:

On Thursday, November 22, 2007 8:52 PM
AK995 wrote:

Conditional Formatting - Code to colour 3+ text values differently
Hi,
In my spreadsheet I would like to highlight 3+ text values in bold and
different colours. E.g. New = green/bold, Modify =blue/bold, Delete =
red/bold, Undecided = yellow/bold.

Conditional formatting only allows you to add 3 conditions. Can someone
provide some code so I can add more than 3 conditions. I would like to apply
the code to the whole spreadsheet (not just a range of cells). Thanks

On Thursday, November 22, 2007 9:55 PM
Gord Dibben wrote:

There are actually 4 conditions if you count the default color.
There are actually 4 conditions if you count the default color.

You have 4 conditions in your example.

Format "New" cells with green/bold then use the 3 CF conditions for the other 3
words.

I'm not sure I would apply to the entire worksheet.

Would you ever use that many cells?

If you have more than 4 conditions you can use event code for multiple
conditions or use Bob Phillips' CFPlus add-in which allows for 30 CF

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


Gord Dibben MS Excel MVP

On Thu, 22 Nov 2007 17:52:00 -0800, AK9955
wrote:

EggHeadCafe - Software Developer Portal of Choice
ASP.NET Simplified Popup Windows and Return Values Redux
http://www.eggheadcafe.com/tutorials...ied-popup.aspx

This link is working right now..............10:11 PST

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


Gord

On Sat, 07 Nov 2009 20:57:20 -0800, Azad Padamsey wrote:

I need a copy of excel cfplus addin.
I can't get it from Bob Phillips web site.the link seems to be broken



Gord Dibben wrote:

There are actually 4 conditions if you count the default color.
22-Nov-07

There are actually 4 conditions if you count the default color.

You have 4 conditions in your example.

Format "New" cells with green/bold then use the 3 CF conditions for the other 3
words.

I'm not sure I would apply to the entire worksheet.

Would you ever use that many cells?

If you have more than 4 conditions you can use event code for multiple
conditions or use Bob Phillips' CFPlus add-in which allows for 30 CF

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


Gord Dibben MS Excel MVP

On Thu, 22 Nov 2007 17:52:00 -0800, AK9955
wrote:

Previous Posts In This Thread:

On Thursday, November 22, 2007 8:52 PM
AK995 wrote:

Conditional Formatting - Code to colour 3+ text values differently
Hi,
In my spreadsheet I would like to highlight 3+ text values in bold and
different colours. E.g. New = green/bold, Modify =blue/bold, Delete =
red/bold, Undecided = yellow/bold.

Conditional formatting only allows you to add 3 conditions. Can someone
provide some code so I can add more than 3 conditions. I would like to apply
the code to the whole spreadsheet (not just a range of cells). Thanks

On Thursday, November 22, 2007 9:55 PM
Gord Dibben wrote:

There are actually 4 conditions if you count the default color.
There are actually 4 conditions if you count the default color.

You have 4 conditions in your example.

Format "New" cells with green/bold then use the 3 CF conditions for the other 3
words.

I'm not sure I would apply to the entire worksheet.

Would you ever use that many cells?

If you have more than 4 conditions you can use event code for multiple
conditions or use Bob Phillips' CFPlus add-in which allows for 30 CF

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


Gord Dibben MS Excel MVP

On Thu, 22 Nov 2007 17:52:00 -0800, AK9955
wrote:

EggHeadCafe - Software Developer Portal of Choice
ASP.NET Simplified Popup Windows and Return Values Redux
http://www.eggheadcafe.com/tutorials...ied-popup.aspx