ExcelBanter - conditional formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - conditional formatting (https://www.excelbanter.com/excel-discussion-misc-queries/115925-conditional-formatting.html)

hobscons

conditional formatting

I'm trying to copy a conditionally formatted cell to a cell on another
worksheet and the formatting is not carrying over. What do I need to do?

Gord Dibben

conditional formatting

CopyPaste SpecialAllOKEsc

OR just Paste SpecialFormat if that's all you want.

Gord Dibben MS Excel MVP

On Tue, 24 Oct 2006 19:10:02 -0700, hobscons
wrote:

I'm trying to copy a conditionally formatted cell to a cell on another
worksheet and the formatting is not carrying over. What do I need to do?

All times are GMT +1. The time now is 03:14 PM.