Worksheet shakes like Rock n' Roll - how check the cell beside upon a singel cell change?

G

Guest

How can I run my format keeping code for that particular cell I make a
change in?
The excel applcation should allow users to copy and paste as they use to do,
without ruin the
code. An ordinary format coditioning wont work because of past commands.
Paste sweep it away...

I tried with a code creating format conditioning rules with For
....Step 1 ... Next for all cells, running at Sub Worksheet_Change, but it
shakes like rock and roll every time you make a change.

I just want to make a check in the cell to the left (A:A) for that specific
row
the change took place (B:B), if that is possible. Font black if RC-1 is "K"
and blue
if it is "I".

Because if I let code create the conditional format on every worksheet
changes, it shakes like rock n roll..

If I want to run code with Sub Worksheet_Change, I guess I had to have a
compleate other approach, right?

Any suggestions??

/My regards
 
Top