Conditional Formatting for two sums

[bokenrosie]

I have a table where the sum of x axis should always equal the sum of y axis. I would like to change the format color of a cell green or red when the sums match, don't match.

I think Home-> Conditional formatting is where I go but don't know what is next.

Thanks.

 

[Momentman]

If Sum of X is in A7 and Sum of Y is in B7, then in conditional formatting>New rule> to use a formula to determine which cells to format, and use =A7<>B7 in the formula box and then choose a format to use

It will be nice to see how your data is structured, for better advice

 

[bokenrosie]

If Sum of X is in A7 and Sum of Y is in B7, then in conditional formatting>New rule> to use a formula to determine which cells to format, and use =A7<>B7 in the formula box and then choose a format to use

Thanks for the response. It will be nice to see how your data is structured, for better advice

It's a situation where teams a, b, c, and d will play each other. Totals for games won goes across x-axis. Adding up Y access is just to reconcile the number of games match.

I don't currently have a sum for them anywhere. Can I embed the sum in the instead of the cell reference?

a b c d
a
b
c
d

 

[Momentman]

It's a situation where teams a, b, c, and d will play each other. Totals for games won goes across x-axis. Adding up Y access is just to reconcile the number of games match.

I don't currently have a sum for them anywhere. Can I embed the sum in the instead of the cell reference?

a b c d
a
b
c
d

Ye you can, like = SUM(A1:A4)<>SUM(B1:E1)