TITLE Link Formatting of Another Cell

[plettieri]

Hello All,


I am trying to retrieve the formatting of the cell that is Matched using the INDEX and MATCH functions and then apply that formatting exactly to a cell currently using this formula:

=IF(D1="","",IF(INDEX('WORK ORDER DATABASE'!W7:W157,MATCH(CO19230COLP!D1,'WORK ORDER DATABASE'!FD7:FD157,0))="","",INDEX('WORK ORDER DATABASE'!W7:W157,MATCH(CO19230COLP!D1,'WORK ORDER DATABASE'!FD7:FD157,0))))

Is this possible without a Macro? If not, I need some walking through using the appropriate Macro as I am a beginning when it comes to VBA. I know its pretty straight forward when looking direct to an absolute cell, but I am lost because it is performing index-match functions.

Thank you in advance for your time and assistance.

plettieri

 

[joshman108]

I'm not sure if that's possible. Are there specific rules that govern the formatting of the cells you are trying to match on? If so, you should be able to use conditional formatting to accomplish this.