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?
Google-sheets – use Google Sheets to Automatically Update Font Styling, Size, Color, etc.
google sheetsgoogle-apps-script
Related Solutions
It looks like Google has recently added a feature to select a font weight. It appears as an arrow in the list of fonts, and clicking it reveals a menu of font weights:
Does the person making the booking really need access to the spreadsheet? Would it be better to make a Google Form which they enter their number and the course into, and which then puts the data into another sheet which has all the helper columns to fill in the rest of the details.
Related Topic
- Google Sheets – Update Column with Last Row Update Except Header
- Google-sheets – How to automatically set “sheets last updated” in a cell on Google Docs Spreadsheets
- Google Sheets Formatting – Conditional Formatting Script to Change Font Size in Google Sheets
- Google-sheets – Use non-linear color scale for conditional formatting in Google Sheets
- Google-sheets – Google Sheets automatically converts a string to a number
- Google-apps-script – Automatically update inserted sheets cells in Google Docs
Best Answer
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
Found in:
Tools > Macros > Record Macro