I know that it is possible using VBE!

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!

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!

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!

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!

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 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

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