How do you select all the blank cells in the selected range?
1) Select the range of cells and press F5
2) Click on 'Special', click 'Blanks' and click OK
This could be used to format all the blank cells in a particular theme.
EasilyExcel by selecting all the blank cells in a few seconds and formatting them!