Challenging Problem
 

OK Guys, I am stumped here once again.

I am trying to figure out how to look up formats on another worksheet
and paste the format (color) to my current table ONLY if there's a
match.

This is the match that I have, but I only want it to implement the
color of the cell, and not the value, and only to do so if there's a
match and not otherwise.

=LOOKUP(C$5,'\\Srvr1\Users\ProdCtrl\Schedulers\[8WeekForecast-Color]Result.xls'!$C$3:$IT$3,'\\Srvr1\Users\ProdCtrl\Sch edulers\[8WeekForecast-Color]Result.xls'!$C4:$IT4)


Anyone have any direction on what the vb code would look like for this?



Thanks in advance, if anyone is able to help with this.

Challenging Problem
 

Formulas can only return values to the cell with the formula. They can't bring
back colors.

Naji wrote:

OK Guys, I am stumped here once again.

I am trying to figure out how to look up formats on another worksheet
and paste the format (color) to my current table ONLY if there's a
match.

This is the match that I have, but I only want it to implement the
color of the cell, and not the value, and only to do so if there's a
match and not otherwise.

=LOOKUP(C$5,'\\Srvr1\Users\ProdCtrl\Schedulers\[8WeekForecast-Color]Result.xls'!$C$3:$IT$3,'\\Srvr1\Users\ProdCtrl\Sch edulers\[8WeekForecast-Color]Result.xls'!$C4:$IT4)

Anyone have any direction on what the vb code would look like for this?

Thanks in advance, if anyone is able to help with this.

--

Dave Peterson