Forum Discussion
How to color a range of cells if the corresponding range is blank or not?
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.
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.