Clear formatting of 'blank' cells that do not contain any value or cell fill.

[Fabulist]

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.

 

[Trevor G]

Try something like this

Sub clearformatEmptycells()
'Change sheet name
Sheets("Sheet1").UsedRange.SpecialCells(xlCellTypeBlanks).ClearFormats

End Sub

 

[Fabulist]

Thanks, but your code clears the formatting of cells that have a cell fill and either have text or are empty.