Operations in Google Sheets
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...
Google Sheets
How to Select Every Nth Row in Google Sheets
You can use the following formula to select every nth row in Google Sheets:
=OFFSET($A$1,(ROW()-1)*n,0)
This formula selects every nth row.
Simply change the value for n...
Google Sheets
Google Sheets: Use an IF Function with 3 Conditions
You can use the following formulas to create an IF function with 3 conditions in Google Sheets:
Method 1: Nested IF Function
=IF(C215, "Bad", IF(C220, "OK",...
Google Sheets
How to Filter by List of Values in Google Sheets
You can use the following syntax to filter a dataset by a list of values in Google Sheets:
=FILTER(A2:C11,COUNTIF(E2:E5,A2:A11))
This particular formula filters the cells in...
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