How to Create Dropdown Lists in Google Sheets
When several people update a task list, the same status can acquire several spellings. A dropdown gives them a shared set of choices. We’ll build five versions of a status …
Google Sheets Tips
Highlight the Highest and Lowest Values in Google Sheets
When you’re working with sales figures, scores, or expenses in Google Sheets, you may want to quickly spot the highest or lowest value without scanning every number. Conditional formatting can …
Apply Conditional Formatting Across Sheets in Google Sheets
You may keep your task list on one tab and its approval status on another. Or you might want sales figures to change color when they pass a target stored …
Highlight Overdue Dates in Google Sheets
When you’re managing tasks or tracking invoices in Google Sheets, it helps to see what’s overdue without checking every date against the calendar. Conditional formatting can highlight those dates automatically. …
Fix Conditional Formatting That Is Not Working in Google Sheets
You’ve created a conditional formatting rule, but the cells haven’t changed color. Or perhaps they have changed, just one row away from where you expected. You don’t necessarily need to …
Highlight a Row When a Checkbox Is Checked in Google Sheets
If you keep a task list in Google Sheets, checking off a finished task is useful. Having the whole row change color makes completed work much easier to spot as …
Conditional Formatting With Multiple Conditions in Google Sheets
When you’re reviewing a task list, highlighting every high-priority task might not be enough. You may only want the ones still in progress, or anything that’s overdue and hasn’t been …
Highlight Cells Containing Specific Text in Google Sheets
When you’re looking through a task list or customer notes, you may want certain words to stand out. Highlighting entries containing “urgent,” for example, makes them easier to spot as …
Highlight Duplicate Values in Google Sheets
When you’re checking a list of customers, projects, or invoice numbers, repeated entries can be hard to spot. Highlighting them lets you review the matches without deleting anything from your …
How to Use Conditional Formatting in Google Sheets
When you’re working with a long list of scores, expenses, or tasks in Google Sheets, it’s easy to miss the entries that need your attention. Conditional formatting helps those entries …