Jun 16 2022 08:26 AM
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
Jun 16 2022 08:31 AM
Jun 16 2022 11:39 AM
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.
Jun 16 2022 11:46 AM