Validate cell equality by conditional fill problem

[ato_zee]

Column G has numerical values, from keyboard input.
Column H has computed values
=SUM(I4161:Z4161) which is repeated and
incremented down through the rows, from
row 3.
=SUM(I4162:Z4162) etc.
I want a conditional fill if the computed
value in column H does not equal the
value in column G.
All values are integers.
A simple data vaildation problem, if
one cell that should have a value is
missed, the =SUM cell turns red, because
the computed value in H does not equal the
value in G.
Have tried several way, for a pair of cells,
the copy paste format down through the range.
Selecting columns G and H and tring to
conditional format, am I missing something?
It's Excel 2007.
Thanks for any replies.

 

[Gord Dibben]

Select column H and Format>CF>Formula is: =$H1<>$G1

Format to red and OK

Note: since the value in G is an entered value it may not be the same as H1 due
to rounding errors from the SUM function.

In that case maybe =ROUND($H1,0)<>$G1 depending upon DP in column G


Gord Dibben MS Excel MVP

 

[pinmaster]

Hi,

In conditional formatting you'll need to make the column reference absolute
(=$G1<>$H1).

Regards!
Jean-Guy

 

[ato_zee]

In that case maybe =ROUND($H1,0)<>$G1 depending upon DP in column G

Many thanks, it needed the ROUND to work, even though all the
values were entered in integers.

 

[Gord Dibben]

Good to hear.

Thanks for the feedback.


Gord

Many thanks, it needed the ROUND to work, even though all the
values were entered in integers.