7

I use a lot of conditional formatting, often with relatively complex formulae to decide the format. Administering them, though, becomes a nuisance - the conditional formatting dialogue is too small and I have yet to find a way to resize it or the columns within it.

Conditional formatting dialogue showing lack of space

Is there any way to enlarge it, whether by normal means or by tweaking a config or something? It seems so outdated to have a fixed size on it with screens as large as they are now.

Andrew Perry
  • 217
  • 1
  • 4
  • 16
  • 3
    I wonder the same. My current workaround is to paste the formulas in notepad (well, technically in notepad++), edit them and then paste them back. But it full like a kludgy workaround. – Hennes Feb 13 '20 at 16:30

1 Answers1

1

I don't think there's an easy way to do this, short of modifying the actual Excel application. Attempting to use the tool AutoSizer (http://www.southbaypc.com/AutoSizer/) only resizes the window the list sits in, and not the list itself which seems to suggest the list size is hard-coded.

Perhaps the best way to work around this is by using a Formula Editor for Notepad++, which you can read more about here: http://dailydoseofexcel.com/archives/2010/09/29/formula-editor-in-notepad/

At least this workaround offers some syntax highlighting and code folding (especially for large formula blocks).

Hope that helps!

Madeleine
  • 51
  • 4