Gray out finished rows
For each row whose status in column E is “Done”, fill the row gray.
Formats, highlights or saves files. Doesn't change your values.
What it does, step by step
- Repeat for each row with data in column A:
- If E[row] is “Done”:
- Fill A[row]:H[row] gray
- End if
- End of repeat
Use it in MacroRoni: open the Starter gallery, search for "Gray out finished rows", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More highlight macros
HighlightHighlight overdue itemsColor the whole row red when the date in column F is in the past.Doesn't change valuesHighlightFlag 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 values