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.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.
