Hi Max,

Thank you very much for your assistance. Your Formula does the job Great!

Cheers,
Sam

Max wrote:
=OFFSET(INDIRECT("E"&INT((ROW(A1)-1)/2)*2+2),,COLUMN(A1)-1)=$B2
Format fill color to taste OK out

Select E2:I11, then apply CF using the formula:
Ensure E2 is the active cell in the selection E2:I11
(The suggested CF formula points to E2, and will be "propagated" from there
to the full range E2:I11)

--
Message posted via http://www.officekb.com