Google Sheet Date Highlighting

Job ID: 40262961

Budget: ₹600 – ₹1,500 INR

I have a Google Sheet that tracks multiple date fields and I need clear, color-coded visual cues. Please set up conditional formatting rules so that:

• Past dates stand out in one colour,
• Upcoming dates in another,
• Weekends in a third.

All rules must update automatically as the calendar moves forward, without requiring manual edits. I’ll share an example sheet; you can either work directly in it or supply a duplicate with the formatting in place along with a brief note explaining the logic so I can adjust colours later if I wish. No other layout changes are required—just the conditional formatting tied to the dates.