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) |