Nov 14 2022 12:40 PM
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!
Nov 14 2022 12:47 PM
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.