formating
7 TopicsKeep conditional formatting range when inserting/deleting cells/rows/columns?
Hi, I sometimes use conditional formatting. For each entry, there's a cell range that it applies to. Often I need it to be used on the entire sheet, or at least a large range of it, i.e. all rows that have content. But then I need to insert or remove data, and that mucks up the range. It seems to copy the entry to the range above, the inserted range, and the range below. I want it to keep the range and entries as they are when I edit the sheet's data. How? I usually enter the range as e.g. $1:$1048576 or $A:$XFD.Solved147KViews3likes41CommentsLookup values invisible on QuickEdit (JSON formatted)
Hi there, I hope you can help. Values on a Choice column appear colour formatted on QuickEdit view. However values in a Lookup column (values taken from a lookup list) are invisible on QuickEdit. The values are there, but are only visible when you click into the cell. Both Choice & Lookup columns have the same formatting. The screenshot below shows how the columns display in regular list view versus QuickEdit view. Attached is the JSON formatting code I have. Can anyone help please? Thanks.1.4KViews2likes1CommentEngineering Notation Formatting Excel
Enhancement Suggestion Engineering Notation Formatting is one of the most useful yet least documented options. This is at least true for electrical or any other field with calculations requiring unit conversions and consolidation. ##0.0E+0 This should be in a more convenient category under beside or under Scientific Category vs 2 mouse clicks and a big scroll deeper as almost undocumented option under "Custom". How does ## make you intuitively guess this means Engineering notation? Ideally would also have option to fix the exponent . i.e so you could stay in the same units nanoseconds or millivolts even if move more than 1000 units.. A suggestion for one of my favorite tools.3.3KViews1like0Comments