Google Sheets
Google Sheets: Conditional Formatting Between Two Values
You can use the custom formula function in Google Sheets to apply conditional formatting to cells that have a value between two specific values.
The...
Google Sheets
Google Sheets: How to Extract Last Word from Cell
You can use the following syntax to extract the last word from a cell in Google Sheets:
=TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),LEN(A2)))
This particular formula will extract the...
Google Sheets
How to Generate Random Dates in Google Sheets
You can use the following basic syntax to generate a random date between two dates in Google Sheets:
=TO_DATE(RANDBETWEEN(DATE(2015,1,1),DATE(2022,12,31)))
This particular formula will generate a...
Google Sheets
Google Sheets: Conditional Formatting Based on Checkbox
You can use the custom formula function in Google Sheets to apply conditional formatting based on the value of a checkbox.
The following example shows...
Google Sheets
Google Sheets: Conditional Formatting from Another Sheet
You can use the custom formula function in Google Sheets to apply conditional formatting based on a cell value from another sheet.
The following example...
Google Sheets
Google Sheets: Conditional Formatting if Another Cell is Not Empty
You can use the custom formula function in Google Sheets to apply conditional formatting to a cell if another cell is not empty.
The following...
Google Sheets
Google Sheets: Conditional Formatting if Another Cell Contains Text
You can use the custom formula function in Google Sheets to apply conditional formatting to cells based on whether or not another cell contains...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read