I have a long and unwieldy formatting condition, currently it's doing 9 function calls, and I'd like to make it even larger.
My trouble is that it's getting increasingly difficult to manage all the parenthesis.
Is there some functionality in spreadsheets to make editing this easier than the tiny text-field used to input conditional formatting?
For context, here's my current formula, though the question is intended to be broader than this particular formula.
=INDIRECT(ADDRESS(IFERROR(MATCH(INDIRECT(ADDRESS(ROW(), COLUMN()-1)), E$3:E$22, 0), 999) + 2, COLUMN() + 3)) + 1