Enlarging the conditional formatting window in Excel

Solution 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!