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, eac...
=(MOD(ROW()/5,1)=0)*(INDIRECT("$B$"&ROW())<>"")
In my sample sheet it works if the conditional formatting rule is written this way.
=(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! 🙂