Hey all,
This probably a silly question but I'm struggling to get it to work. Basically I have a formula in a worksheet that multiple people use. Often times they adjust the formula by adding numbers to the end or something. The formula is something like this --
=SUM(SUMIFS('2024Data'!$R:$R,'2024Data'!$C:$C,"2024",'2024Data'!$D:$D,$G$21,'2024Data'!$G:$G,{"11*"}))/1000-AC24-AC25
Basically I want to do conditional formatting to make sure the formula stays the exact same and no one changes it. If someone adjusts the formula, I want the background to go red. What should I enter into the Rule formula to make this work? Thanks all!
This probably a silly question but I'm struggling to get it to work. Basically I have a formula in a worksheet that multiple people use. Often times they adjust the formula by adding numbers to the end or something. The formula is something like this --
=SUM(SUMIFS('2024Data'!$R:$R,'2024Data'!$C:$C,"2024",'2024Data'!$D:$D,$G$21,'2024Data'!$G:$G,{"11*"}))/1000-AC24-AC25
Basically I want to do conditional formatting to make sure the formula stays the exact same and no one changes it. If someone adjusts the formula, I want the background to go red. What should I enter into the Rule formula to make this work? Thanks all!
