Forum Discussion
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()...
But wouldn't be much easier to create a rule of type 'Format only cells that contain' with Cell Value, greater than, and =1 ?
Yes, definitely much easier. captainFlow mentioned this was for demonstration purposes. Maybe he can share his goal?