Conditional formatting: highlight dates in current week
How to apply conditional formatting based on dates that fall in the current week. Syntax and example using a Gantt chart and weekly tasks.
Conditional formatting
CONDITIONAL FORMATTING of non-adjacent cells in Excel
To apply conditional formatting in Excel to non-adjacent, non-sequential cells.