Hello Experts!
Another question that I am incapable to resolve - oh and btw i dunno if
this is the right forum to post in!!
I have several sheets with data and cells that are manually colour
coded for their approval status.
Then I have a summary page that colates all the info with the folowing
formulas:
In cell A1: =IF(Sheet2!A1=0,"",Sheet2!A1)
Is there a way to colour the cell in the same way as the cell it links
from?
Many thanks
--
Petitboeuf
------------------------------------------------------------------------
Petitboeuf's Profile:
http://www.excelforum.com/member.php...o&userid=10602
View this thread:
http://www.excelforum.com/showthread...hreadid=547465