Traffic Light Icons Conditional Formatting in Excel

🚦 Track CVRT Due Dates with Traffic Light Icons in Excel! 🚦

In this video, I'll show you how to use Conditional Formatting with traffic light icons to track CVRT (Commercial Vehicle Roadworthiness Test) due dates in Excel. ✅🟠🚨

👉 Green Light – Due more than 30 days from today (Safe Zone)
👉 Amber Light – Due within 30 days, including today (Warning Zone)
👉 Red Light – Overdue (Critical Zone)

This is a quick and easy way to keep your fleet organized and avoid missing important CVRT dates!

💡 In this video, you’ll learn:
✔️ How to set up traffic light conditional formatting
✔️ How to customize the rules to match your data
✔️ How to make the icons update automatically based on dates

👍 If you found this helpful, don’t forget to like and subscribe for more Excel tips and tricks!

Traffic light icons created by xnimrodx - Flaticon → https://www.flaticon.com/free-icons/traffic-light

🔔 Subscribe to Pivot & Roll → https://www.youtube.com/@PivotAndRoll

💬 Got questions or suggestions? Drop them in the comments below — I’d love to hear from you!

Видео Traffic Light Icons Conditional Formatting in Excel канала Pivot & Roll