Apr 18 2024 04:42 AM
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)=0
works in cell, but not in conditional format
=AND(MOD(ROW()/5;1)=0;INDIRECT("$B$"&ROW())<>"")
Apr 18 2024 04:53 AM
Solution=(MOD(ROW()/5,1)=0)*(INDIRECT("$B$"&ROW())<>"")
In my sample sheet it works if the conditional formatting rule is written this way.
Apr 18 2024 04:56 AM
Apr 18 2024 04:53 AM
Solution=(MOD(ROW()/5,1)=0)*(INDIRECT("$B$"&ROW())<>"")
In my sample sheet it works if the conditional formatting rule is written this way.