I have been creating a contact list in Google Sheets to continually add and update names, emails, organizations, etc. for work. I am often copying and pasting this information from other sources as to avoid typoes. I know I can paste as special, though at times I am copying and pasting a handful of entries and this would take more time than I would like. Is there any way to have a script automatically change the font styling of a cell (size, bold, background, typeface, etc.) if it doesn't match the default?
You can use macro that records your desired font, size, cell color etc. It's a script that don't need coding. You may check more info on this link
Tools > Macros > Record Macro