Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Conditional Formatting

Copper 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



This rule for conditional formatting works in my sheet.



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