Forum Discussion
captainFlow
Oct 20, 2022Copper Contributor
conditional formatting doesn't work with complex "IF" statement
=IF(INDIRECT(ADRESS(ROW();COLUMN()))>1;1;0) It doen't work, when I put it in the formula for conditional formatting, but for example when I try to separate it and use "INDIRECT(ADRESS(ROW();COLUMN()...
JMB17
Oct 25, 2022Bronze Contributor
captainFlow
Oct 28, 2022Copper Contributor
JMB17
Hi
Yes, it really works. I've tryed handle it with 'index' function, but couldn't finish it because of lack of experience. Big thanks :]
P.S. Getting current cell value via code seems little strange in that way XD;