Conditional formating

G

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
 
G

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
 
Top