In this guide, I’ll walk you through the simple steps to set up conditional formatting to identify functions in Google Sheets.
How to Check if a Cell is a Function Using Conditional Formatting
Posted on 02/04/2024
Category: Web Stuff
Everything done on the web that is entirely unrelated to WordPress.
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
Send WhatsApp Messages From Google Sheets
How to make a google sheet that allowed the sending of WhatsApp messages to a list of recipients in a Google Spreadsheet.
Posted on 11/12/2023
Schedule Google & Outlook Calendar Events Using Google Sheets
Automatically schedule Google & Outlook calendar events using a simple list within a Google Sheet as a starting point.
Posted on 25/09/2023
How To Make Miraheze Require Email Confirm To Edit
How to change Miraheze settings to require email confirmation to edit a page on your wiki.
Posted on 31/08/2023
Age From Date of Birth On Power Virtual Agents
Here’s how to take a users date of birth and calculate their age in years while factoring in months and days.
Posted on 05/06/2023
