I'm trying to import data "and" formatting from one sheet to another. I'm using =importrange("docID", "sheetName!A1:A30") to get the data, but it doesn't get the format.


  • 2
    This can only be done with an Apps Script, unfortunately (and it can't be a custom function, since they can't access other spreadsheets). See Cell reference with colour formatting – user79865 Jan 21 '16 at 19:57