Conditional formating

[glen.e.mettler]

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

 

[Francisco GMAIL]

activecell.interior.colorindex

 

[glen.e.mettler]

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