Formatting blank cells

Occasional Visitor

Help! I’m looking to highlight a blank cell if there is data in the cell before or after. I must select hundreds of blank cells, so it doesn’t help when they all highlight. 

thank you! 

1 Reply



You don't say whether "before" and "after" means to left and right OR above and below. In the example here I've used the cells to left and right to illustrate how a conditional formatting rule could be set.