Forum Discussion
Formatting blank cells
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!
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.