sahasranama
New Member
- Joined
- Apr 5, 2018
- Messages
- 2
Can you help me, please?
I have a few rows that share a merged cell. When this merged cell is not empty, I want the rows to highlight. Currently, the formula (applied over G5:G72) is "=NOT(ISBLANK($M5))" and then fill. Works for the 11 row, but not on the other four.
[/IMG]
[/IMG]
[/IMG]
I have a few rows that share a merged cell. When this merged cell is not empty, I want the rows to highlight. Currently, the formula (applied over G5:G72) is "=NOT(ISBLANK($M5))" and then fill. Works for the 11 row, but not on the other four.
![yHnaCCV.png](/board/proxy.php?image=http%3A%2F%2F%5BIMG%5Dhttps%3A%2F%2Fi.imgur.com%2FyHnaCCV.png&hash=07f4b1e78baf1b97768ed02406513d75)
![6fJ0Erx.png](/board/proxy.php?image=http%3A%2F%2F%5BIMG%5Dhttps%3A%2F%2Fi.imgur.com%2F6fJ0Erx.png&hash=95c58901e979585caaced7bd1e8e47f2)
![xTeoFHT.png](/board/proxy.php?image=http%3A%2F%2F%5BIMG%5Dhttps%3A%2F%2Fi.imgur.com%2FxTeoFHT.png&hash=d2f6625581969ccf14b6c1e38469d5d7)