Adaptive Conditional Formatting

[MrMetrics]

Hi,
I am currently trying to make a rule that will alert people that an incorrect value has been entered in table use to track metrics. The value entered in column D should equal the sum of values entered in columns G, H, I and J. I can make the rule apply to a single row in the table, but I want to be able to apply it to the entire table without having to make a new rule for every row. I feel like there should be a way to do this but I can't seem to figure it out.

 

[Fluff]

Hi & welcome to MrExcel.
How about like

=$D2=SUM($G2:$J2)

 

[MrMetrics]

Hi,
So that's similar to what I currently have, but wouldn't I have to make a new rule for every row of the table? When I tried every row of column D was checking against the sum of row 2 instead of their respective rows.

 

[Joe4]

Hi,
So that's similar to what I currently have, but wouldn't I have to make a new rule for every row of the table? When I tried every row of column D was checking against the sum of row 2 instead of their respective rows.

If that is true, then I am guessing that your formula probably looked like this:

=SUM($G$2:$J$2)

Note the "$" in front of the row numbers.
Now, note that Fluff's formula does NOT have those.

If you put the "$" in front of a row or column reference, it "locks" in that row/column.
If you leave them off, it will allow them to "float".
Try Fluff's way, and I think it should work the way you want (select the whole range you wish to apply it to first, then enter the formula as it applies to the first row, and if you leave the "$" in front of the row numbers off, it will automatically adjust for all other rows).

See here for a complete description of range references: Relative and absolute cell reference: why use $ in Excel formula

 

[MrMetrics]

Ah, yes, that was exactly the problem. Thank you! Everything is working as it should be now!

 

[Joe4]

You are welcome.
Glad we were able to help!