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 FormatCFFormula 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

On Sat, 1 Dec 2007 20:23:10 GMT, wrote:

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.

Hi,

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

Regards!
Jean-Guy

" wrote:

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.

On 1-Dec-2007, Gord Dibben <gorddibbATshawDOTca wrote:

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.

Good to hear.

Thanks for the feedback.


Gord

On Sat, 1 Dec 2007 21:35:54 GMT, wrote:


On 1-Dec-2007, Gord Dibben <gorddibbATshawDOTca wrote:

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.