Excel Excel due and overdue date colours


Joined
Sep 6, 2018
Messages
2
Reaction score
1
I have a few cars in a garage I look after maintenance on , and want to create a spreadsheet that automatically tells me when a date is overdue.
I have used conditional formatting to change a date when its due in 30 days to yellow, and over the date to red.
wjt I want to do is add another column to automatically change to say DUE or OVERDUE etc

thanks
 
Joined
Mar 14, 2018
Messages
446
Reaction score
139

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Colour code dates 1
Excel Remove Excel Background Colours 1
Excel Excel Show Countdown Date 7
Excel Change Excel Text colour from Formula Bar 0
Excel Convert .DAT to Excel 2
Excel What does "P"means in Excel 1
Excel Export Filtered Form Data To Excel 0
Excel Date Setting 1

Top