Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Format, copy down
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Format, copy down
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 "CLR" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Format, copy down
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 "Mike" wrote: 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 "CLR" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Format, copy down
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 "CLR" wrote: 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 "Mike" wrote: 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 "CLR" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy conditional format without using format painter | Excel Worksheet Functions | |||
Copy conditional format | Excel Discussion (Misc queries) | |||
Conditional format won't copy | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |