This didnt work. In column I:U, column I, K, M, O, Q, S and U. I will
color cell in the respective row of column G. only if in all cell of a
row of I, K, M, O, Q, S and U contain a numeric value except a zero or
blank. What i meant is that in for example in row 4. All the cell I4,
K4, M4, O4, Q4, S4 and U4 all must contain a numeric value except a
zero or blank, then the respective cell in column G (G4) will be color.
This is used to indicate that all the different product uses this part
thus is common to all. Sorry for all the trouble i have caused. Thanks