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