I have been working on a large project (organizing a large amount of data) and would like to bulk enter conditional formatting rules (over 150 rules to start). I searched here a bit (new to the forum so figuring out how advanced a search can be still) and did not see anything on this.
Basically, where and how are conditional format rules saved and is there a way to edit that file??
(As a larger note, if someone knows a bit about organizing existing data with semi-consistent categories please reach out! I will share the project when it is organized enough to be used).
An example of what I want to input is this:
B21:AMJ21 → Format is → EXACT(B21,$A$21)
B22:AMJ22 → Format is → EXACT(B22,$A$22)
B23:AMJ23 → Format is → EXACT(B23,$A$23)
B24:AMJ24 → Format is → EXACT(B24,$A$24)
Because this: B10:AMJ10,B11:B40,F12:F39 → Format is → EXACT(B10,$A$10) Does not work.