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.
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).
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?
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
How to do conditional use formatting if for example a vendor has weekly limit of Invoice posting limit how to highlights on which week the limit got exceeded . Please advise
How do I get excel to highlight when multiple expiration dates expires in a single cell or about to be expired? Example 1, expired Cell A1: (4/28/2019)(7/5/2019). Example 2 Cell A2, about to be expired (5/25/2019)(12/12/2019).
I tried this and it worked great, except that I was using < "less than" instead to highlight any cells with dates after today 29/09/22, but it highlights all cells dated 20/09/22 through to 03/10/22 (the list goes from 20/09/22 to 10/10/22). I can't work out why. My formula is =$L12
Thank you! This is exactly what I needed!!!!
In less than a minute, I learned exactly what I came here for, plus, got a bonus tip with ctrl + backspace. Thanks!
Great tutorial, Thanks.
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.
Ctrl Backspace I didn't now and my student have often asked. Good stuff.
Nice Vid! Always having trouble with applying rules and not getting them messed up?
Thank you so much! After searching extensively for answers your video gave me exactly what I needed. Much appreciated!
Really helpful - thanks so much, Chester
Great and easy way of explaining the
topic, thank you very much.
Thank you, this was very helpful!!
Brilliant - great pace and easy to follow :-)
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).
So the solution was staring me in the face the entire time... got it. THANKS!
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.
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?
I needed that info in a hurry, thank you.
How do you do this if you need a date range larger than a month in the future?
Thank you very much, this is exactly what I needed for my Project management sheet!
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
THANKS A LOT.
I tried this formula for highlighting past dates =$G21
Hi Elfin4, thanks for your question. You need an AND statement, something like this =AND($G21
@@ChesterTugwell Thanks for that, appreciate you replying.
How to do conditional use formatting if for example a vendor has weekly limit of Invoice posting limit how to highlights on which week the limit got exceeded . Please advise
Did you solve the issue ?
Great, exactly what I needed!
if only ten dates want to condition formatting to highlight ,how can i do ?thanks
What if I want to highlight the cell when today's date is one week or more passed the due date?
how can I do the same if my interest is finding items that are oversue by a week or a month?. Thanks
I need to know how to highlight a date greater than 36 months relative to the current date. Thanks
If i have to automatically highlight a particular date every month, how to go about it?
How do I get excel to highlight when multiple expiration dates expires in a single cell or about to be expired? Example 1, expired Cell A1: (4/28/2019)(7/5/2019). Example 2 Cell A2, about to be expired (5/25/2019)(12/12/2019).
Thank you
I tried this and it worked great, except that I was using < "less than" instead to highlight any cells with dates after today 29/09/22, but it highlights all cells dated 20/09/22 through to 03/10/22 (the list goes from 20/09/22 to 10/10/22). I can't work out why. My formula is =$L12
i need formul excell if condition it will come day and date automaticaly
how to insert date and time of future in excel