Conditional Format, copy down

C

CLR

Hi All.........
I have code which puts a 3-level Conditional Format in a cell, U9. I would
like to copy just that CF down the column U as far as there is data in column
C. I've tried, but just don't seem to be able to get it right, and recording
don't help.

TIA
Vaya con Dios,
Chuck, CABGx3
 
M

Mike

Easier than you think.

Select the range you want the conditional format copied to but ensure the
range contains the cell whose format you want to copy. Click Format -
conditional formatting - OK and your done
 
C

CLR

Thanks Mike, but I don't know how to select the range down column U by
macro....it varies, depending on the values in column C, in fact, there may
even be blanks down column U, but not in C............

Vaya con Dios,
Chuck, CABGx3
 
C

CLR

Ok Mike, I got it.........I was finally able to select that dynamic range and
copy the CF down.........thanks for the lead...

Vaya con Dios,
Chuck, CABGx3
 

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

Top