Use Formula IS D164/not equal to/G162

"Riccol" wrote in message
...
I'm trying to put a double-check in place and as easy as it seems it
ought to be, I can't get it to work right.

D164 - formula is =SUM(D160:D163)

G162 - formula is =G40+G80+G120+G160
(This cell is a merged cell, so it's actually cells G162 and G163)

To double check that the values of D164 & G162 match, I'm trying to add
conditional formatting to D164.

I've tried:

Cell Value IS/not equal to/G162

and

Cell Value IS/not equal to/G163

and

Cell Value IS/not equal to/G40+G80+G120+G160

The format should be red and strike-thru if values don't match.

The values DO match, but for each of the above conditions I tried, the
number in D164 is shown in red and strikethru.

What am I doing wrong? (Besides using merged cells, which I see from
reading here is frowned upon.)


Stu wrote:
As a double
check, you could set up totals for E5 thru E100 and for the derived sums
for the individual companies, and set conditional formatting to colour
the cell red if these do not match???