Conditional formating  
Author Message
resolutionie7





PostPosted: Wed Apr 05 19:27:48 CDT 2006 Top

Excel >> Conditional formating

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

Excel349  
 
 
Francisco





PostPosted: Wed Apr 05 19:27:48 CDT 2006 Top

Excel >> Conditional formating activecell.interior.colorindex




 
 
glen





PostPosted: Thu Apr 06 08:13:55 CDT 2006 Top

Excel >> Conditional formating 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