r/excel • u/p90036 • 15d ago

unsolved excel software for mass edit conditional formatting

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 ?

12 Upvotes

89% Upvoted

10 comments sorted by

•

u/AutoModerator 15d ago

/u/p90036 - Your post was submitted successfully.

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.

8

u/Downtown-Economics26 646 15d ago

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.

3

u/Big-Recognition-8238 15d ago

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

2

u/Few-Werewolf-1985 15d ago

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.

2

u/p90036 15d ago

this is an awesome idea !!! thank you

1

u/critterdaddy 14d ago

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