Conditional Formatting

New Contributor

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,

Screenshot 2022-09-15 17.41.34.png

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. 

Screenshot 2022-09-15 17.48.46.png

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.

1 Reply

@Boyneelec 

=($F4=SUM($I4:$T4))*(F4<>"")

This rule for conditional formatting works in my sheet.

format.JPG

=$F$4:$F$23

The "applies to" range starts in row 4 as well.