Conditional formatting excluding empty cells
use a formula to determine which cells to format -- an option in
conditional format
in the formula, use =isblank (A1)
when the formula return true, the selected format will be
applied....and that should highlight the blank cells
|