Trying to format a cell to change to red when two other groups of cells dont equal each other. So the scenario is I am a sum of 9 cells that should equal the sum shown in ONE seperate cell. I then want a third cell to be displayed as red when the sums of these two other cell groups do not equal each other....

Is there a way in conditional formatting to state where you fill in the formula "does not equal"?