Conditional formatting

[Opgelost]

Dear all,

I want to do the following.

Highlight the cell in column G and H if the total value of the cell in column G and H is not the same as the value written in the corresponding cell in column E.

So for example:

G1 (100 euro) and H1 (2900 euro) together are 3000 euro, but the cell E1 is 2900. This should make excel to highlight cell G1 and H1, because the value is not the same as E1. But is if the value is in E1 3000 euro, than it should NOT highlight E1, because the value is the same as the total value of G1 and H1 together.

Thank you very much!

Kind regards,

 

[FDibbins]

1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =$G1+$H1<>$E1
format fill as needed