LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Worksheet shakes like Rock n' Roll - A command like Cells_Change would have been nice

How can I run my format keeping code only when a range of cells changes?

I'm looking for a solution to keep my format in some cell areas in column
B:B. The format need to be of two different choices, depending on if you got
an "I" or an "K" in the cell to the left, in A:A column.

It should allow users to copy and paste as they use to do, without ruin the
code. 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 for that specific row
the
change took place, if that is possible. Font black if RC-1 is "K" and blue
if it is "I",

I have tried to start from a macro when recording format conditioning in
excel. A part of it look of cource like this:
...
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=$A$6:$A$102=""I"""
With Selection.FormatConditions(1).Font
.Bold = True
.Italic = False
.ColorIndex = 1
End With
.... etc

If I want to run code with Sub Worksheet_Change, I guess I had to have a
compleate other approach than "=$A$6:$A$102=""I""" Right?

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

Any suggestions??

/My regards


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
very nice........... john adam Excel Worksheet Functions 0 December 10th 08 07:15 PM
Nice pics jkmnhdjdjk Excel Discussion (Misc queries) 4 December 5th 06 08:39 AM
Allllen you rock!!! Jen711 Excel Worksheet Functions 0 November 8th 06 06:20 PM
'Save current worksheet'; 'Open next worksheet' - two command buttons englishmustard Excel Discussion (Misc queries) 1 April 7th 06 12:54 PM
Nice Dodo Excel Discussion (Misc queries) 0 August 18th 05 02:09 PM


All times are GMT +1. The time now is 03:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"