Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey fellows
I have struggled a while now and need your help. I have two columns: The left has several ranges (A6:A22;A24:A36 ...) with cells only with value "K" or an "I" It can only accept "K" or "I" The right (B6:B22;B24:B36 ...) has a text as you like It has to accept copy and paste from other worksheets and within it self. Solution/Problem ONE - The format sweep away with paste action. I have tried with EnableControl subs but paste doesn't work - maybe it's my one of my subs: - "worksheet_activate" - "ActiveSheet.Unprotect" ...causing it, what do you think? Solution/Problem TWO Conditional formatting can't solve it. It has to be relative references (?), from Column B:B to column A:A because I don't want to use a For ... Step 1 .... Next sub because that is not nice to work with, if I combine it with a Worksheet_Change sub.... stepping all the time... Could you please help me...? Thanks!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional format ref., diff work sheet | Excel Worksheet Functions | |||
Conditional format does not work for some cells | Excel Worksheet Functions | |||
Any solution in order to have union of format using Conditional Fo | Excel Discussion (Misc queries) | |||
Copy/Paste Conditional Format | Excel Discussion (Misc queries) | |||
Copy & paste conditional format | New Users to Excel |