ExcelBanter - Conditional formats- paste special formats?

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

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

- - Conditional formats- paste special formats? (https://www.excelbanter.com/excel-discussion-misc-queries/164419-conditional-formats-paste-special-formats.html)

jcarney

Conditional formats- paste special formats?

I have cells highlighted with conditional formats. I want to copy the cells
that are highlighted onto another sheet and have the cells stay the same
color even when the number is changed?

Bob I

Conditional formats- paste special formats?

Then you will need to use Format, Cells, Patterns, and select the
desired color.

jcarney wrote:

I have cells highlighted with conditional formats. I want to copy the cells
that are highlighted onto another sheet and have the cells stay the same
color even when the number is changed?

All times are GMT +1. The time now is 07:19 PM.