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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet shakes like Rock n' Roll - A command like Cells_Change would have been nice 1
Excel Msgbox runing beyond posted cell range. 1
#N/A Conditional Formatting affects all cells? 9
Macro to copy a Cell Content automatically IF G12 cell <>"" 6
Insert blank row after change in cell value not working. 1
Hide/Unhide worksheets upon entries in a range of the main worksheet 5
2 'myStr' values in one Worksheet, need VB Code help! 3
How do I change the color of cells with a macro 3

Back
Top