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

[DonkeyOte]

Short answer, no, not with in-cell formulae alone.

It may be (without knowing the specifics) the case that should logic be determining the format of the source cell (ie conditional formatting) then that same logic can be applied to the "link" cell.

[avidcat]

Thanks, I am working on that now instead.