Conditional formatting - colour both cells when they don't equal another cell

[Skumby]

I have a daily balancing sheet for our receptionist to use at the end of day to balance the money taken for the day.

I have added a new section so she can enter how much goes into our Municipal account and how much goes into the Trust account.

I need both G28 and J28 to BOTH turn red the added together they don't equal G24.

I have trying to use =SUM($G$28:$J$28)<>G24 but its only changing the colour of one cell, not both.

The purpose is so if they put in the amount for each bank but it doesn't equal the total amount we took for the day it alerts them that there is an error.

[guru008]

To color both when the value is not matching

select these cells go to - conditional formatting - choose new rule - formula to determine which cell and put below code

=g2<>j2 set the conditional format you want

[Skumby]

Sorry but I don't understand how that will work. I would have thought the start of the formula would include adding G28 & J28?

[protonLeah]

The formula, =SUM($G$28:$J$28), sums four cells g, h, i & j

Select G28 & J28 and apply CFF:

=AND($G$28<>($G$24-$J$28),$J$28<>($G$24-$G$28))

[guru008]

use in formula (G28+J28)<>G24 in this case

Sum(G28:J28) will sum g28+h28+i28+j28 i.e. will include all 4 columns

[Skumby]

This is the formula I has originally using but it is only changing the colour of one of the two cells I want to change. I need it to change both cells if they don't both equal G24

I have attached my spreadsheet.