How to color a range of cells if the corresponding range is blank or not?

New Contributor
4 Replies



Rather than doing it for you, let me point you to a resource where the "how" is described, so you can do it for yourself.


Thank you, I've been looking into conditional formatting for a while now but an IF logic statement based on the condition of another cell is something I'm having a hard time finding/ understanding.
I'll see if I have any luck with this resource though.



No need for an IF


Getting Conditional Formatting rules straight (workable) is sometimes tricky. But it will get there if you keep trying. I just wrote the above. And it works. If cell A1 is blank, B1 gets a red background.

Yeah, I think I could have spent most of my work day today on it and this is a pretty big project so this is a massive help thank you so much.