Hi all,
I have a huge data where I need to copy and paste conditional formatting. When I paste around 550 rows consisting of CF, it will copy paste just fine. However, when I paste around 1000 rows then it would not display any formats, although the cells do have CF rule embedded in them.
Would appreciate a workaround this weird behavior in Excel.
Btw I am using Excel 2019 latest built.
Thanks.
I have a huge data where I need to copy and paste conditional formatting. When I paste around 550 rows consisting of CF, it will copy paste just fine. However, when I paste around 1000 rows then it would not display any formats, although the cells do have CF rule embedded in them.
Would appreciate a workaround this weird behavior in Excel.
Btw I am using Excel 2019 latest built.
Thanks.