Formatting a blank cell

[Needsomehelp365]

Help! I’m looking make a formula/conditional formatting 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!

 

[jasonb75]

Assuming that you are looking at a column and you want to look at the cells above and below, using a formula like this as a rule will highlight A2 if it meets your requirements.

=AND(A2="",OR(A1<>"",A3<>"")

Note that the first part refers to the cell that should be blank, the second and third parts refer to the adjacent cells of which at least one should contain data.
Once you set it up for a single cell you can expand the range that the rule is applied to as necessary.