I typically apply a conditional format to an entire column. Sometimes while sorting or copy/pasting, it gets all jacked up and makes multiple copies of the same formatting but only applied to some cells in the column. Every once in a while I have to go and manually fix this by making one apply to the entire column and deleting the rest. This can take a lot of time and be very frustrating especially if there is multiple format conditions. In some cases of 10+ formatting conditions, after a few copies or sorts, I'll have hundreds of fragmented formats to sift through. Also, the ability to group a set of formats together, so they can be applied to a range together and copied together to another sheet.

Post on Microsoft Community Answers - "When Excel shows this dialog after a copy (CTRL+C) action, it means that another app has a lock on the system clipboard. In this situation you can still paste within Excel. However you cannot paste to another app like Word or Outlook which uses the clipboard.

Last year we made some improvements to Office365 users so that this error message only shows once per Excel instance. This is based on customer feedback - the design change prevents it popping up multiple successive times when the clipboard is locked. We have also considered never showing the error dialog, but there was user feedback that this message is informative and helpful in some cases."

Why not develop the ability for multiple instances of the clipboard to work with a copy/paste command from each app? When several apps are open at the same time, give each it's own clipboard instance to keep the data "clean". After the command is executed, when the app closes, clear it's clipboard and close its clipboard.

I was working here in a spreadsheet that contains a range with like 50 cells filled with quite large formulas, and all formulas uses, by more than one time a reference to cell $Q$1 that shall contain an integer number.
Problem is, it is a requinted layout and I need to make a simples small chage where I deleted Q column and then the new $Q$1 cell had a text on it, wich was previously the R1 cell. Naturaly all the formulas got an error, of course. But when changed the value of Q1 to a integer number I noticed the formulas does not worked anymore. By inspectioning this I found the $Q$1 reference in formulas was all replaced with this string "#REF!".
Luckly I had saved before doing the layout changes, if not it would e painful to fix.

By killing two rabits with one shot. Editing large formulas in Excel 2016 can be very bad due to lack of a large text box to do so, and even more because when you reach the right limit it forward all the characters left like changing a page. I'm using notepad to help with complex formulas here.

Thank you for your time.

This function should work like an extended version of IFERROR. An expression value shoud be checked against a value (array of values?). If it matches that value (any of them), then the value_if_matched results. Otherwise, the checked expression itself is the result of the function.

If the syntax was: IFVALUE (expression, value_to_match, value_if_matched), then

IFVALUE("great idea", "", "no match") results to "great idea".
IFVALUE("", "", "empty string") results to "empty string".

I very often have to check, if the result of a complex expression results to zero or an empty string; if not, the expression is the result. This woud become much easier to write, read and maintain.

In a current project, the expression is (german version of excel):

WENN(AY9;WVERWEIS(INDIREKT(AW9&ZEILE(AW9));INDIREKT("'Werke'!"&AX9);4;AY9);WENNFEHLER(WVERWEIS(INDIREKT(AW9&ZEILE(AW9));INDIREKT("'Werke'!"&AX9);4;AY9);WVERWEIS(0;INDIREKT("'Werke'!"&AX9);4;AY9)))

so, in the formula this expression occurs twice :-(