Highlight Dates DUE Within 3 Months of Expiry Date 🕛 | Excel Tutorial

[@Computergaga]

Fast track your Excel learning and enrol in the Ultimate Excel course today bit.ly/UltimateExcel

[@lescourcha8964]

Thank you I've gone grey trying to figure this out. it's not quite what I need to do but it almost is I need a column next to the date that will change to orange when it three months out and a second column that changes to blue when it is two weeks out and a third column that goes black when it has expired. The black one I have done. but I've been stuck on the other two until you explained it in a way that is simple to understand. Thanks again

[@josevelazquez4645]

How can I create a training metrix that highlights with in 60 yellow and 30 days red? For a yearly tracker, I am in the Army and I have to track many trainings for 20 Soldiers.

[@kebincui]

Good videoo. Thanks Alan.👍

[@Computergaga]

Thanks 👍

[@nadermounir8228]

Thank u Alan for this great Video 📹 👍

[@Computergaga]

You are very welcome

[@IvanCortinas_ES]

Good job. Thank you.

[@Computergaga]

Thank you 🙂

[@Manualtherapy166]

WHY ITS NOT HAPPENING WITH MY EXCEL, EVEN FROM THE BEGGINING .. WITH THE FIRST FORMULA .... I DON NOT UNDERSTAND ...
PLEASE HELP

[@Computergaga]

I would need to see what you're experiencing. This formula has been around a long time, so there should not be any trouble.

[@samiodeh3785]

👍👍👍👍👍👍👍👍👍👍👍

[@Computergaga]

😊

[@PaulEBrownbill]

:-) thanks

[@Computergaga]

My pleasure.