Conditional formating-Is there a way to get the background coloring also?

I am pulling data from another worksheet that contains background cell
colors. I get the data just fine. Is there a way to get the
background coloring also?

Glen

activecell.interior.colorindex

Here is my formula that pulls data from another spreadsheet (gets data
from every 5th row)
=OFFSET('Proposal Status'!$G$5,ROW(G1)*5-5,0)

How can I incorporate the "activecell.interior.colorindex" into that?


Glen