Forum Discussion
Conditional formatting crash Excel 2021
Hello, I have a problem with a .csv file containing 278017 rows. I want to use conditional formatting to highlight duplicate values in a column. However, at the time of performing this condition...
I have a problem with a .csv file containing 278017 rows.
I want to use conditional formatting to highlight duplicate values in a column. However, at the time of performing this conditional formatting Excel 2021 crashes, as does its online version on Office 365.
<snip> </snip>
Is it normal for Excel to crash? Is there a solution to make it work?
No, it's not normal for Excel to crash. Does it sometimes crash? Yes.
It's also not "normal" to try conditional formatting in a CSV file. Have you tried saving it first as XLSX?
