Forum Discussion
Jarx_
Dec 29, 2023Copper Contributor
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 conditional formatting Excel 2021 crashes, as does its online version on Office 365.
Here's my configuration:
AMD Ryzen 9 5900x (8 cores 16 threads)
16 GB DDR4
RTX 3050 2GB
1 TB SSD NVME
Is it normal for Excel to crash? Is there a solution to make it work?
Thanks in advance,
ARNOUX Joey
- mathetesSilver Contributor
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?