.
.
Click B12
Click Conditional Formatting on Menu Bar
Select "Format only cells that contain" / Equal to
In the formula field enter =("")
Format color for BLACK
Click Ok / APPLY /OK
Test B12 by selecting the blank item
When confirmed it works ... Click B12 again.
Click FORMAT PAINTER on HOME TAB in the CLIPBOARD section
Left click and hold on B12, then drag down the column as far as you need.
|