0

I have been looking all day for a way to use getValue or getDisplayValue to be able to keep the formatting that I am pulling into another spreadsheet with Apps Script. The source cell contains words in red text, and when I pull it in with either getValue or get DisplayValue, I lose the red color. Is there a way to do this within the original code or would I have to write a second function to find those specific cells in the new file with that wording, and then make them red?

TinaT
  • 1
  • 2
  • 1
    You can copy the entire sheet temporarily and then use copyTo() and then delete the temporary sheet. – Cooper Apr 06 '23 at 22:55
  • Does this answer your question? [Copy value and format from a sheet to a new google Spreadsheet document?](https://stackoverflow.com/questions/25106580/copy-value-and-format-from-a-sheet-to-a-new-google-spreadsheet-document) – Kos Apr 07 '23 at 06:50
  • I am just looking to get a few cells from several spreadsheets and then combine them into one list. One of the source cells is in red, but when it pulls it into the new combined spreadsheet, it is no longer red. – TinaT Apr 07 '23 at 13:06

0 Answers0