Validate cell equality by conditional fill problem

  • Thread starter Thread starter ato_zee
  • Start date Start date
A

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.
 
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
 
Hi,

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

Regards!
Jean-Guy
 
In that case maybe =ROUND($H1,0)<>$G1 depending upon DP in column G
Click to expand...

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