Xavier,

Select your cells, from A1 to J????, and use the formula

=ISODD(CODE($A1))

Then set your fill color to yellow.

HTH,
Bernie
MS Excel MVP


"Xavier" wrote in message
ups.com...
Thanks, but the problem is, this pattern repeats a few thousand times.
So for every other set or rows (ie... those containing values A, C, E,
G, I, K, etc), I want to color the cell yellow. The cells containing
the values of B, D, F, H, J, etc would be colored white. The problem
is, the instances of these data values vary. So 'A' could occur 3
times, 'B' could 1 time, C could occur 2 times, D could occur 10 times,
and so on. Therefore, I would need to color fill the entire row
containing varying instances of these values in alternating colors.
Thanks!