Formula bar should change colour when not all information is visible
If you have a formula that spans more than one row, but the formula bar height is set to one row, then it can be easy to overlook some information in the cell.
In such instances, the formula bar could change colour to indicate to the user that there is information in the cell that can't be seen in the formula bar.
Stefano Gatto commented
I would prefer that the Formula Bar automatically expands when necessary. Or have an option to choose between the color approach and the automatic expansion approach
Kenneth Barber commented
I know what you mean. Sometimes, to do the OR condition for SUMIFS, I have multiple SUMIFS like this:
But then I remember that I should forget the alignment and write this instead to show that the line is incomplete:
Col Delane commented
Better still, make the Formula Bar always expand/contract to display the full formula (as Peter G's VBA code in the 'Excel User Group' does: http://excelusergroup.org/forums/p/2791/9610.aspx)
Please also for the mac version