Hello

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.