Excel Conditional Formatting for Dates in the Past/Future/Today

This video covers the following topics
-Condtionally format dates within a time period - yesterday, today, last week etc
-Use conditional formatting to identify overdue invoices
-Writing a formula for conditional formats
-Using the TODAY() function within a conditional formatting rule
------------------------

[crysbradley]

In less than a minute, I learned exactly what I came here for, plus, got a bonus tip with ctrl + backspace. Thanks!

[justinhowell]

Thank you! This is exactly what I needed!!!!

[analirpisani]

Ctrl Backspace I didn't now and my student have often asked. Good stuff.

[DonovanJenkins]

Thanks for this! I was forgetting the () after today. Your video gave me exactly what I needed. And CTRL + Backspace was new to me, so thanks for that too.

[jennifergreggs]

Really helpful - thanks so much, Chester

[susanflabiano]

Thank you so much! After searching extensively for answers your video gave me exactly what I needed. Much appreciated!

[thebesttechnical]

Great and easy way of explaining the
topic, thank you very much.

[Dwavard]

Brilliant - great pace and easy to follow :-)

[reszzz]

So the solution was staring me in the face the entire time... got it. THANKS!

[MmeDesgranges]

I needed that info in a hurry, thank you.

[Derpderpson]

Thank you very much, this is exactly what I needed for my Project management sheet!

[msearch]

Nice Vid! Always having trouble with applying rules and not getting them messed up?

[ethelmurray]

Great advice, however it is highlighting all dates in the future for me. I'm not sure where I am going wrong, if anyone can help me.

[naimahersy]

How to insert a COUNTIF function to count values once it reaches to the first zero value to stop. And count again the cells between the first zero and second zero. any help will be appreciated

[marleycook]

How do you do this if you need a date range larger than a month in the future?

[donovang]

How do you get a cell to highlight when IT'S date has passed? I have cells that get updated after client contact and it auto generates another date either 3 or six month from last contact. So if the date in the next follow up cell has lapsed I would like it to highlight itself. Any idea?

[matthewhunter]

What if I want to highlight the cell when today's date is one week or more passed the due date?

[henryquattlebaum]

I need to know how to highlight a date greater than 36 months relative to the current date. Thanks

[Elfin]

I tried this formula for highlighting past dates =$G21<TODAY() as shown in the video however it also highlighted blank cells. How do you stop the conditional formatting highlighting blank cells ?

[TeePolgar]

Hello Chester,
Do you have a tutorial on the following or can you advice what steps to take?
I want to create a spreadsheet for applicants where they need to list their employment (employment history) but after providing the leave date (month/year) for employment A, they must use next month for employment B (either actual employment or gap reference).