Forum Discussion
Boyneelec
Sep 15, 2022Copper Contributor
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 has disappeared and no matter how I frame the formula it will not work.
The following image is the real sheet that the rule will be used in, using the cells in column F as the target and the cells in column's I to T as the accumulators.
In English, I want the TOTAL cells in Column F to change colour when the entered value's in the adjacent DATE column's equal the total.
I really hope this makes sense.
Any help would be really appreciated.
- OliverScheurichGold Contributor
=($F4=SUM($I4:$T4))*(F4<>"")
This rule for conditional formatting works in my sheet.
=$F$4:$F$23
The "applies to" range starts in row 4 as well.