remove colored rows
Hi ligang
I didn't understand clearly, would you please describe in detailed,or write
complete code or macro.
regards
" wrote:
On Nov 7, 5:53 pm, climate wrote:
Hi
I have 2 columns that many of it's rows has colored ( colored cells in
first and second column is equal) , i want to remove colored rows.
Would you please help me?
regards
climate
yes, you have to use macrofun
1, define a name, say "color" ---- insert-name-define,
"=get.cell(63,sheet1!A1), suppose the colored cells located in column
A
2, insert a column next to column A
3. enter a formula, say B1"=color",and drag down the formula
4. data filter, auto filter, customer "not equals to 0", at this time,
you can get all the colored rows
5. delete the rows,
6. done.
cheers.
ligang
|