Fill Color Rows of Varying Size
Ignore my last formula - I forgot that ISODD isn't allowed in CF formulas.
Use thi formula as your CF formula:
=MOD(CODE($A1),2)=1
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!
|