How do I preserve font/size when sending text to a different cell

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

I am making a template for a restaurant menu and have the complete menu
listed on the page. The menu I am creating is on the same page and would
allow me to select only items a customer may want on a "personalized menu".
So, I have set up formulas to insert the items I check off on the complete
menu to be automatically inserted on the personalized(or limited) menu.
There are different fonts and sizes to the text I am inserting. Is there a
way to keep these so that what is inserted is exactly the same font and size
as on the complete menu?
 
Formulas return values only.

Formatting must be done separately.

Conditional Formatting may do the trick for you.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to search and replace cells 0
How to automatically fill up a cell when a range of cells are filled up? 1
How do I change fonts in a DV drop down menu 1
matching columns to find differences. 0
How do I increase the font of my drop-down menu options? 2
Inserting an Item into cells with text 2
How to find max value in a range then give value in cell 2 rows above that max 1
VLOOKUP - MULTIPLE RETURNS 4

Back
Top