Thanks Boki (Berg).
The 1st Question is : the one line bgcolor is clRed, another line bgclor is clGreen, next line bgcolor is clRed, next line bgclor is clGreen, clRed, clGreen, ......
The 3rd Question is : example column(2) value has 'A' or 'B' or 'C', use col.Filter='A' can only display column(2) string equal 'A' cells, how set can i to only disply column(2) string equal 'B' or 'C' , without 'A'
Look forward to your reply