Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting -
I wish to copy (programmatically) a range that has conditional
formatting associated with it, and I want the same conditional formatting to appear in the destination range. Is there an easy way to do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting -
The solution depends on the condition of the formatting.
For example, if it's simply to format the cell if a value is equal to, greater than, less than, etc. a certain value, all you have to do is: 'Where A1 has your conditional format 'and A2 is your destination Range("A1").Copy Range("A2").PasteSpecial Paste:=xlPasteFormats Application.CutCopyMode = False If your conditional format is a formula, pay attention to the absolutes in the formula. The dollar signs before the columns and rows will keep those references the same when you copy the format. So if the formula is: =$B$1+$B$2=2 meaning to format the cell if the values in B1 and B2 sum to 2, copying the format will not change the formula. But this formula: =B1+B2=2 (no dollar signs) will change so that it is now relavent to the new location. Hope that helps, tod -----Original Message----- I wish to copy (programmatically) a range that has conditional formatting associated with it, and I want the same conditional formatting to appear in the destination range. Is there an easy way to do this? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting -
hi,
it is to my understanding that conditional formats can be copied and pasted. if you use the copy command and use the pasteall command, this should carried the conditional formats with it. -----Original Message----- I wish to copy (programmatically) a range that has conditional formatting associated with it, and I want the same conditional formatting to appear in the destination range. Is there an easy way to do this? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |