Highlight overdue items
Color the whole row red when the date in column F is in the past.
Formats, highlights or saves files. Doesn't change your values.
What it does, step by step
- Rows with a past date in F2:F1000 turn red
Use it in MacroRoni: open the Starter gallery, search for "Highlight overdue items", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More highlight macros
HighlightFlag what's due this weekColor rows yellow when the date in column F is within the next 7 days.Doesn't change valuesHighlightSpot large amountsColor amounts over 1,000 in column B green.Doesn't change valuesHighlightFind duplicates and missing cellsColor repeated IDs in column A and every empty cell, without changing any values.Doesn't change values