Forum Discussion
Retaining (or fixing) conditional formatting
Microsoft Excel 2019 MSO 64-bit Lenovo E490 I have a list (several lists) of daily data for entire years. Each day has a value and a conditional format – typically the highest and lowest 5 per...
Monodon Hi there,
I just tried to understand the issue:
1 - You wanna to copy your file where conditional formatting applied. To do so, use Paste Special from where, first select, Format, Then Formulas or Values. Everything remains the same. Regarding colors, make sure that you use the same color pattern (Page Layout - Colors).
2 - If you want to divide table where Conditional Formatting applied into some tables based upon on Months, so Conditional Formatting range should be changed in each table manually.
Once again, I answered based upon on the level of my understanding.
Good luck.