Essential Skill with Excel: Expiration Alerts with Conditional Formatting

preview_player
Показать описание

In this video we'll be learning how to use conditional formatting to create expiration alerts in Excel.

In order to actually get to the conditional formatting, we'll need to know how to use the IF function, the TODAY function, a simple substraction.

The Today function in excel is going to be necessary in order to figure out which dates are due, or nearing due. =TODAY() in excel is dependent on the computer clock.

The =IF() function in excel will figure out, using conditional logic, if we have an expired or non expired invoice. We'll also use a nested if function to add a middle "about to expire" warning.

Finally, we'll be using the Text that Contains conditinal formatting rule to highlight with different colors the cells that are expired or on time.

As an added bonus, we'll use an excel pivot table to count how many invoices are expired.
Рекомендации по теме
Комментарии
Автор

This video was so helpful!! I used this to organise my assignments and it works like a charm. thank you!

lilakarisma
Автор

AMAZING VIDEO! Thank you so much for helping. Clear and step by step instructions :)

kalistaflowers
Автор

This video was so easy to follow. I have finally found one that I can easily understand and not get confused.

jasminehang
Автор

dude thanks so much!! I am doing a work report and this is exactly what I needed! thank you so much, very clear instructions! Subscribed

officialveronicawrites
Автор

Man thanks for this, you are the best. Your video helped to fix the best document for our maintenance team to not forget all service days in our production.

mohamedyusufmohamed
Автор

Very useful ! Use of pivot tables at the end has given a summary.

rajeshkumarsharma
Автор

Thank you so much. U make it more easier to understand! I have very limited knowledge with excel since i rarely use before. Done Subscribing your channel. Will refer to your channel to explore more about excel.

nurizzatirossdi
Автор

So easy to follow, you're a great teacher, ty!

fakdolan
Автор

Learning step by step, love it, thank you

fahdiqbal
Автор

You my friend are a life saver. Thanks!!

sagarabrian
Автор

Your explanation is really good!!! Thank u so much

van
Автор

Great Sir, What a beautiful and detailed explanation, love it. Thanks

raheelkhokhar
Автор

Thank you for makinf it look so clear and easy!

LarPam
Автор

This video was very helpful for my internship project. Thank you very much!

dbhakimi_.
Автор

11:37 Noooo, we're not bored at all! Thank you for NOT skipping any steps (however irrelevant) 😊

bxcinderella
Автор

Although the quality of the video is not really clear yet I learnt a lot from it.
Thank you very much

theophilusdada
Автор

Thank you so much the video was really helpful and explained it in a very clear and easy way.

AbdulrahmanAlahdal-lcwz
Автор

Amazing and very easy to understand, Thank u so much...

watajs
Автор

After watching this video i believe "NOTHING IS IMPOSSIBLE" Thanks a lot it was really helpful for my project ...

mmmm-xmfc
Автор

Thanks a ton man...🤗 Its a great help 💐

rahulpawar