Forum Discussion

Judge4's avatar
Judge4
Copper Contributor
Dec 15, 2019

Copying a Range of Color Fill

I have a range of cells with formulas that have various color fills.  I want to transfer the color fills only to a separate range of cells that also include formulas.  Can this be done?  Thanks.  

excel

1 Reply

  • Abiola1's avatar
    Abiola1
    MVP
    Dec 15, 2019
    Hello,

    I will advice that you use Format Painter located Clipboard group of the Home tab to copy and paste the fill color to the range of cells you want to transfer to..

    Kindly let me know if this helps.

    Cheers

Resources