Forum Discussion
Solved
excel formula doesn't work in conditional format
Hello all,
I am a little stunned. I created a formula with an and link, which works fine within a cell.
But it doesn't work within the conditional format. If I try each part of the and link, each for its own works.
Please let me know where I messed up. Thanks.
works in cell & conditional format
=INDIRECT("$B$"&ROW())<>""works in cell & conditional format
=MOD(ROW()/5;1)=0works in cell, but not in conditional format
=AND(MOD(ROW()/5;1)=0;INDIRECT("$B$"&ROW())<>"")
=(MOD(ROW()/5,1)=0)*(INDIRECT("$B$"&ROW())<>"")
In my sample sheet it works if the conditional formatting rule is written this way.
2 Replies
=(MOD(ROW()/5,1)=0)*(INDIRECT("$B$"&ROW())<>"")
In my sample sheet it works if the conditional formatting rule is written this way.
- wow that's easy. Thanks!
Is there an explanation why this way is excepted and the other one not? Would love to understand it for future reference.
Thanks again for the quick response and solution! 🙂