how can i use the match destination formatting button ?

Hi @Vincent Roman (Belfius),

Thank you for posting your question in the Microsoft Q&A forum.

To use the Mach Destination Formatting feature in Excel, there are several methods you can use:

Method 1: With Paste icon

• First copy the cell or range of cells you want with Ctrl + C
• Select the destination cell and right click in that cell
• Under Paste Options there will be a series of icons. In that list, you will choose the Formatting (R) icon which having a paint brush

Method 2: With Paste special

• Using the same step in Method 1, you need to first copy the cell or range of cells you want with Ctrl + C and select the destination cell
• Go to the Home tab, under the Paste button there is a small arrow.
• After clicking that arrow, you will see a list of options, you can choose between these three which I highlight below

I hope the information provided proves useful. Please proceed with the outlined steps and let me know whether they resolve the issue. If not, I’ll be glad to continue working with you to find a solution.

Thank you for your patience and understanding throughout this process. Should you have any questions or need further assistance, feel free to reach out at any time.

I look forward to hearing from you.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".          

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread