How to Highlight Overdue Dates in Excel - Simple Tutorial

This tutorial shows you how to highlight overdue dates in Excel using Conditional Formatting. It also shows you how to combine multiple criteria, for example an unpaid and overdue invoice.

[vvvIIIPP]

What if i want it to also read another cell? Like for example, if a cell says CLOSED but the date is outstanding, I don't want the date to be red but revert back to automatic? I have a column that has a drop down with open, and closed. I have a column with rules that say if the date is outstanding, the text will turn red. I want the dates to go back to black when the other cell/column is switched to 'closed'. What formula would I use?? Please and thank you!

[jackiewood]

Hello!!! Perfect for one year, what if I want it to be years?

[da]

Hi. Does this example also apply to excel on a Mac? I ask as it does not appear to work for me. Thanks.

[samuelomoyibo]

Thanks for this, Lisa Doe referred me to u. Pls is there a way to adjust the width of two cells simultaneously in excel without affecting the width of other cells. Just the way the width of two cells can be adjusted in ms word by highlighting the two cells and dragging the centre border to adjust the width.
Looking forward for a response. Thanks.

[da]

Sorry. To add; I want multiple conditions met before formatting a cell. I.E. Due Date is less than TODAY() and progress (a column on my excel spreadsheet) < 100%. And that formatting applied the relevent cells in a column. Thanks.

[rozetagoxhaj]

this video is not clear at all, the formula it doesn't showed at all