Conditional formatting crash Excel 2021

Copper Contributor

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

1 Reply

@Jarx_ 

 

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?