copy the formatting from one sheet to another sheet in calc

[clos911]

I have a calc file with a few sheets, my main sheet has conditional formatting on columns A thru M, the conditions are for numbers and will trigger a style for the number. pretty standard.

I would like to copy or = only the formatting on my main sheet onto another sheet in the file in the same corresponding cells. I do not want to copy the number. I would like it to copy whether it’s the conditional formatting style or the default style.

thank you

[mikekaganski]

Copy the cells/rows/whatever you need, then Edit▸Paste Special▸Paste Special...; and in dialog, unselect everything except Formats.