Google Sheets script - multiple fonts
Budget: £10 – £15 GBP
Hi there
I need a script added to Google Sheets which enables me to do this:
- In cell D2, have formula "=B2&C2", where B2 is in one font (Libre Barcode 128) and C2 is another font (Proxima Nova), and D2 displays the two DIFFERENT fonts, rather than pasting their VALUES only. So D2 would contain two different fonts in one cell.
- I am aware that 2x different fonts can be displayed in one cell if done manually, but this doesn't work using formulas. It always converts to a single font.
- I have experimented with this script (https://stackallflow.com/webapp/cell-reference-with-color-formatting-in-google-sheets/) and it successfully takes the formatting (font, background colour etc etc) from one cell, but it doesn't work with multiple cells.
I look forward to hearing your solutions.
Thank you
Jay
I need a script added to Google Sheets which enables me to do this:
- In cell D2, have formula "=B2&C2", where B2 is in one font (Libre Barcode 128) and C2 is another font (Proxima Nova), and D2 displays the two DIFFERENT fonts, rather than pasting their VALUES only. So D2 would contain two different fonts in one cell.
- I am aware that 2x different fonts can be displayed in one cell if done manually, but this doesn't work using formulas. It always converts to a single font.
- I have experimented with this script (https://stackallflow.com/webapp/cell-reference-with-color-formatting-in-google-sheets/) and it successfully takes the formatting (font, background colour etc etc) from one cell, but it doesn't work with multiple cells.
I look forward to hearing your solutions.
Thank you
Jay
Related categories:
Google Sheets