# Conditional Formatting for two sums

#### bokenrosie

##### New Member
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.

### Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
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

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

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)

Replies
2
Views
721
Replies
2
Views
214
Replies
6
Views
445
Replies
9
Views
563
Replies
0
Views
127

1,221,119
Messages
6,158,051
Members
451,459
Latest member
Austin2550

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back