Need help on the attached internal audit tracker. In the Column, "Tracking", I have added the difference between the due date and TODAY. How do I conditional format with 3 colors - one for today (yellow), Less than due date (green) and overdue (as red)?
Also how to create graphs (like a pie) for the total # of yellow, green and red with percentages?
Thank you in advance
Also how to create graphs (like a pie) for the total # of yellow, green and red with percentages?
Thank you in advance