Transferring origin cell colour into destintation cell.

[coleman09]

Hello,

I am working with Excel 2013.

My main issue is transferring over the cell colour of the origin cells into the destination cell that contains the formula.

I have two formulas being used:

a) is being used to identify the 2nd largest value in my data set.
This formula is in cell AS104
=SMALL(CHOOSE({1,2,3,4,5,6},E104,K104,Q104,W104,AC104,AI104),5)

E104 is blue/K104 is red/G104 is orange/W104 is green/AC104 is grey/AI104 is teal.

b) is being used to identify the largest value in the same set of data.
This formula is in cell AP104
=MAX(E104,K104,Q104,W104,AC104,AI104)

E104 is blue/K104 is red/G104 is orange/W104 is green/AC104 is grey/AI104 is teal.

Whichever value is generated, as per the formula, the destination cell remains with no fill colour.
The colour of the origin cell (as mentioned above) is not transferred over. How would I go about achieving this, to maintain the orginal cell colour in the destination cell, with the formulas mentioned above, or different formulas that will achieve the same result.

I would truly appreciate any and all assistance.

Thank you kindly,

Scott C.

[newdoverman]

Worksheet functions will not do as you want. It will take VBA, I think, to copy the formatting along with the cell contents.