A simple Google Apps Script that I came up with to change the colour of every link within the current active sheet all at once.
Change Colour Of All Links On Active Google Sheet
Posted on 29/07/2024
Tag: Code
All types of code.
From Shortcode, CSS, SCSS, PHP (maybe a little JavaScript) and HTML on WordPress.
To C++ in Arduino and Java in Android.
Show Block After Set Date Shortcode
Announcing an event or closing a vacancy? Here’s a shortcode for your WordPress child theme that shows a block only after a predetermined date has passed.
Posted on 16/04/2024
New EU Consent Requirements for Google Analytics
A simple explanation of Google Analytics’ new EU consent rules and how to satisfy them with a simple script.
Posted on 03/04/2024
How to Check if a Cell is a Function Using Conditional Formatting
In this guide, I’ll walk you through the simple steps to set up conditional formatting to identify functions in Google Sheets.
Posted on 02/04/2024
MailChimp Popup Button
A simple script that you can use to make your MailChimp popup form button activated rather than spamming every new visitor with the popup.
Posted on 02/04/2024
Get Sheet Name in Google Sheets Function
A simple bit of Google Apps Script for a Google Sheet to add a function which returns the name of whatever sheet it’s placed within.
Posted on 02/04/2024
Strip Domains From List of Emails
A simple formula that I use to strip domains (such as “hotmail.co.uk”) from long lists of email addresses in Google Sheets.
Posted on 06/02/2024
Create a Folder Using Google Spreadsheet
A simple guide on how to create a folder at the press of a button using a Google Spreadsheet.
Posted on 18/01/2024
Format Names “Last Name, First Name” in Google Sheets
A simple function that can be used to take a name and extract only the surname and forename separated by a comma in all uppercase.
Posted on 11/01/2024
Updated Sheet to Calendar
An improved version of my code for scheduling Google & Outlook calendar events using a simple list within a Google Sheet as a starting point.
Posted on 11/01/2024
