| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
can i freeze conditional formating to copy to another worksheet
I have a worksheet with conditional formating (red, green or no-fill) to
highlight data. I want to copy the data and the cell colour to another standalone spreadsheet. I know it is possible to replace a formula with its result. Is there some way to achieve the same effect for the conditional formating before I copy to the second sheet? |
|
#2
|
|||
|
|||
|
One way if the range is small is to copy that range, paste into MSWord and then
copy from there into the other worksheet. Chris Lane wrote: I have a worksheet with conditional formating (red, green or no-fill) to highlight data. I want to copy the data and the cell colour to another standalone spreadsheet. I know it is possible to replace a formula with its result. Is there some way to achieve the same effect for the conditional formating before I copy to the second sheet? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Command conditional formating | Excel Worksheet Functions | |||
| HOW DO I COPY A CONDITIONAL SUM (sumif) AND EDIT IT? (THE SUM NEV. | Excel Worksheet Functions | |||
| more than 3 conditional formating in excel | Excel Discussion (Misc queries) | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Linear Mode
