Formula to copy a cells value and also its formatting.

[avidcat]

I am curious if it is possible to copy a cells formatting, Color Shading etc. along with the value to another cell.

I am using the formula below to gather data from another sheet, but I would also like to copy the formatting of that cell also.

=IF(OR(ROWS($B$25:$B25)>$O$26,$C$1="",COUNTBLANK($B$4:$B$5)=2),"",INDEX(Tracking!A:A,MATCH(ROWS($B$25:$B25),Tracking!$M:$M,0)))

I appreciate any help.

Thanks,
Nick