Expiration Date Alerts with Conditional Formatting in Excel | Over Due, On time, Paid Out Highlight
ฝัง
- เผยแพร่เมื่อ 3 ต.ค. 2024
- In this Excel video tutorial, we gonna se how to do an Expiration Date Alerts with Conditional Formatting in Excel | Over Due, On time, Paid Out Highlight
In this video we gonna see how to use the conditional formatting to create an expiration alerts in Excel Sheet.
With the conditional formatting, we gonna use the IF function in Excel or If formula Excel, also the Today function, to help us maintaining the spreadsheet always update and some simple math such as substractions.
The Today function in excel is necessary in order to make or worksheet update and to figure out which dates are due or on time.
=TODAY()
This function is dependent on the computer clock.
The =IF() if function in excel or the if formula, is one of the best formulas in excel because it's can help us to automate task, such as automatically create the status.
Then, we gonna use the conditinal formatting tool to to highlight specific cells when a criteria is met.
#JopaExcel #Dashboard #Excel
👏👏👏
Excellent video. I had to slow it down a bit but you are so thorough and helpful. Thank you!
Thank you so much, very helpful and something I needed.
Subscribing because I learned a lot in this channel. Thanks a lot!
Impressive demo
Thanks a lot. It's such a great video .
Thanks for this awesome learning video!
Glad you enjoyed it! 🙏👍
Thank you sooo much!! This helped me out
Glad it helped!🙏👍
Great video! thanks!
Thanks for sharing😊
Your video is helpful but try to Show the whole page, row and column should be visible
Hi, great video. Just hope to ask, is it possible to make multiple rules for showing different alerts based on certain specifications?
For example,
Alert level for Brand A is 1 month
For Brand B is 3 months
and Brand C is 6 months
Could we make it so that the formulae can detect which brand this product is referring to and quote the warning/alert in accordance with it?
What if the amount of due date days is 5 working days?
thank you
In days of expiration I want to Exclude Saturday as well. How can I do this
Can this also be done on google sheets?
100%. However, the way to do it can change a bit. I will try to bring more videos about Google Sheets. 👍
Formula eror 😢