Excel Excel due and overdue date colours

[hillbilee001]

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

 

[Abraham Andres Luna]

You will want to use the IF function to determine if the date is past the date. Here is a link explaining the IF statement: https://support.office.com/en-us/article/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2

Use some of the same logic from your conditional formatting to test the date and return "DUE" or "OVERDUE"

Here is a link to the Excel Community Forums: https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat

 

[hillbilee001]

great thanks done it - all sorted.