I linked Excel data to a ppt deck and I want to edit the format of that linked data in the ppt, while keeping the data from the Excel cell and not altering the formatting of the Excel cell itself.
I linked an Excel cell to a PowerPoint deck using:
- Ctrl+c+cell
- Make text box in PPT
- Paste special
- Select paste link, select Microsoft excel worksheet object. This creates an image of the cell linked from Excel in the ppt.
Current Result:
In Excel: C2 = 800, is blue, with border, Calibri font
In PPT, after I linked to C2 to a textbox, I that textbox has the same value of 800, is blue, with border, Calibri font
Desired Result:
In Excel: C2 = 800, is blue, with border, Calibri font
In PPT, after I linked to C2 to a textbox, I want that textbox to have the same value of 800, be green, without border, Time New Roman font
I am open to all solutions ranging from clicking buttons to making a macro in VBA.