Forum Discussion

Jarx_'s avatar
Jarx_
Copper Contributor
Dec 29, 2023

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

  • mathetes's avatar
    mathetes
    Silver Contributor

    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?

     

Resources