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

New Contributor
4 Replies

@JosephHester 

 

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.

https://exceljet.net/lessons/what-is-conditional-formatting

 

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.

@JosephHester 

 

No need for an IF

mathetes_0-1655404634716.png

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.