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
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 multipl
conditions or use Bob Phillips' CFPlus add-in which allows for 30 C
http://www.xldynamic.com/source/xld.CFPlus.Download.htm
Gord Dibben MS Excel MV
Previous Posts In This Thread:
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.
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
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 multipl
conditions or use Bob Phillips' CFPlus add-in which allows for 30 C
http://www.xldynamic.com/source/xld.CFPlus.Download.htm
Gord Dibben MS Excel MV
EggHeadCafe - Software Developer Portal of Choice
ASP.NET Simplified Popup Windows and Return Values Redux
http://www.eggheadcafe.com/tutorial...a67-185762ec9c6e/aspnet-simplified-popup.aspx