Hello,
Would it be possible to clear the formatting cells that do not contain anything, including text, and are also not filled with color?
There is a massive spreadsheet, that has had multiple rows inserted over the years, which rows have shared the same formatting (usually alignment, bold or not) of their preceding row, but are empty and can be restored to their default condition as with real unformatted cells (e.g. default formatting of a new sheet). All filled cells (color, pattern, etc.) are to remain as they are/
Is this possible with VBA or any other way? I cannot figure out if this is possible simply with find and replace.
Attached, a file where only formatting of cells with no values of any kind or fill should be cleared (e.g. A1 to B1 & A17 to B17 but not I15 to I17 etc.)
New Microsoft Excel Worksheet
Thank you in advance.
Would it be possible to clear the formatting cells that do not contain anything, including text, and are also not filled with color?
There is a massive spreadsheet, that has had multiple rows inserted over the years, which rows have shared the same formatting (usually alignment, bold or not) of their preceding row, but are empty and can be restored to their default condition as with real unformatted cells (e.g. default formatting of a new sheet). All filled cells (color, pattern, etc.) are to remain as they are/
Is this possible with VBA or any other way? I cannot figure out if this is possible simply with find and replace.
Attached, a file where only formatting of cells with no values of any kind or fill should be cleared (e.g. A1 to B1 & A17 to B17 but not I15 to I17 etc.)
New Microsoft Excel Worksheet
Thank you in advance.