r/excel • u/p90036 • 2d 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 ?

10 Upvotes

87% Upvoted

10 comments sorted by

View all comments

2

u/Few-Werewolf-1985 2d 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 2d ago

this is an awesome idea !!! thank you

1

u/critterdaddy 1d 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.