Forum Discussion
Conditional Formatting
Hi all, I had made a rule that turned a cell,(A4), orange once the sum of the adjacent cells,(B4:J4), were equal to the value of that cell,(A4), see image for example, but somehow the rule...
=($F4=SUM($I4:$T4))*(F4<>"")This rule for conditional formatting works in my sheet.
=$F$4:$F$23The "applies to" range starts in row 4 as well.