How to increase number of "conditional format"
I know that it is possible using VBE!
|
How to increase number of "conditional format"
Take a look at http://www.xldynamic.com/source/xld.....Download.html
-- HTH RP (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I know that it is possible using VBE! |
How to increase number of "conditional format"
What abt using VBA?
"Bob Phillips" wrote in message ... Take a look at http://www.xldynamic.com/source/xld.....Download.html -- HTH RP (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I know that it is possible using VBE! |
How to increase number of "conditional format"
It is not trivial, as that addin proves (which is VBA), as taking care of
many likelihoods takes a lot of code. If you just want a simple event based test you can use something like Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range("A1:H10")) Is Nothing Then With Target Select Case UCase(.Value) Case "b": .Interior.ColorIndex = 5 Case "o": .Interior.ColorIndex = 46 Case "p": .Interior.ColorIndex = 7 Case "r": .Interior.ColorIndex = 3 'etc. End Select End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "crapit" wrote in message ... What abt using VBA? "Bob Phillips" wrote in message ... Take a look at http://www.xldynamic.com/source/xld.....Download.html -- HTH RP (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I know that it is possible using VBE! |
How to increase number of "conditional format"
Any other alternative?
"Bob Phillips" wrote in message ... Take a look at http://www.xldynamic.com/source/xld.....Download.html -- HTH RP (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I know that it is possible using VBE! |
How to increase number of "conditional format"
Any other alternative to the CFplus? It seems to be quite slow!
"Bob Phillips" wrote in message ... Take a look at http://www.xldynamic.com/source/xld.....Download.html -- HTH RP (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I know that it is possible using VBE! |
How to increase number of "conditional format"
How about just running the code on demand.
The formatting won't change until you run the macro and you'll have to remember to run the macro when you change data (or when you're done changing all the data). crapit wrote: Any other alternative to the CFplus? It seems to be quite slow! "Bob Phillips" wrote in message ... Take a look at http://www.xldynamic.com/source/xld.....Download.html -- HTH RP (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I know that it is possible using VBE! -- Dave Peterson |
How to increase number of "conditional format"
It doesnt seems to work sometimes
"Dave Peterson" wrote in message ... How about just running the code on demand. The formatting won't change until you run the macro and you'll have to remember to run the macro when you change data (or when you're done changing all the data). crapit wrote: Any other alternative to the CFplus? It seems to be quite slow! "Bob Phillips" wrote in message ... Take a look at http://www.xldynamic.com/source/xld.....Download.html -- HTH RP (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I know that it is possible using VBE! -- Dave Peterson |
All times are GMT +1. The time now is 06:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com