Thread
:
Validate cell equality by conditional fill problem
View Single Post
#
2
Posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
Posts: 22,906
Validate cell equality by conditional fill problem
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.
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben