Forum Discussion

Copper Contributor

Oct 20, 2022

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()...

excel

Formulas and Functions

JMB17

Bronze Contributor

Oct 25, 2022

captainFlow

Maybe try:

=IF(INDEX(INDIRECT(ADRESS(ROW();COLUMN())), 1)>1;1;0)

captainFlow
Copper Contributor
Oct 28, 2022
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;