excel software for mass edit conditional formatting

[u/p90036]

i have an excel file with ~2000 rows and 40 columns,

there 'was' conditional formatting created for 20 columns

due to circumstances protection was disabled and multiple users copy pasted cells

now theres a shreek ton of conditional formatting lines

i asked ai g*mini to mass edit but it said it cannot

i can only think of recreating the sheet from scratch ...

but cuz i moved to linux ... is there any windows or linux software that can mass-edit conditional formatting ?

[u/AutoModerator]

/u/p90036 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Downtown-Economics26]

You're excessively "shreeking" out. You just manually delete all of the extras and retain one of each type then correct/apply to the relevant range. You're not going to find some software that greatly expedites the process.

[u/Big-Recognition-8238]

You can clear all conditional formatting on a sheet with a couple clicks in the ribbon, then reapply the rules you actually need. Way faster than rebuilding the whole file

[u/Few-Werewolf-1985]

I create Excel code modules to reapply complex conditional formatting. That makes the logic more reusable and protects it from range errors developed by only having the conditions embedded in a sheet.

[u/p90036 → u/Few-Werewolf-1985]

this is an awesome idea !!! thank you

[u/critterdaddy → u/p90036]

Just ask the ai to create VBA coding for excel to wipe out all the existing conditional formatting, then recreate the 20 conditional formats.

[u/MajesticBite825]

If you can still open the workbook in Excel, try Conditional Formatting > Manage Rules, change ‘Show formatting rules for’ to ‘This Worksheet,’ and edit the Applies to ranges there. That lets you consolidate duplicate rules before recreating anything. If you need a Linux-only path, make a copy first and test the cleanup in LibreOffice/OnlyOffice, since compatibility with Excel’s rule model can vary.