Just what i needed!!! Very helpful, Thank you.

This was super quick and easy compared to other methods I found on the internet. Thank you so much!

Very Useful Clear and Simple Thanks

Damn useful content within 2-3 minutes! Thanks a lot!

This was quick and useful. Thank you so much!!!!

Thanks Brother, it was so easy but I couldn't catch it before this video. Stay blessed ❤

Thank you for this. easy to follow along

Great Summit, thank you

Thanks, explained simply......

Excellent Video - Thank you1

Great initiative sumit... I do appreciate your efforts.. As I am working on excel from last 5 years but these are great tricks..

tq sumit very useful information

Thanks this tips help with my work

Hey, buddy! Thanks a lot for this video. Really useful! Although, as someone mentioned below, empty cells get formatted too. How can I avoid that? Thanks in advance and keep up the good work! You've got a new follower ;)

Great stuff

Hi Sumit.. great tips on conditional formatting for dates. Thanks for sharing. Thumbs up!

@trumpexcel

4 жыл бұрын

Thanks for commenting Wayne.. Glad you liked the video :)

Thanks !

Very helpful. Thank you.

@trumpexcel

4 жыл бұрын

Thanks for commenting... Glad you found the video useful!

Wow! I watched this the same day it was uploaded :) Today() = 13/10/2019 By the way, great work Sumit !! Your videos are among the best in KZread!

@trumpexcel

4 жыл бұрын

Thanks for the kind words George.. Glad you found the video useful :)

Thanks for this video. Is it also possible to do this with vba?

Helpful

Very useful trick 👌 Yet simple solution 👍

@trumpexcel

4 жыл бұрын

Thanks for commenting Devendra.. Glad you found the video useful!

Nice video

Hi, what if we have more versions and have separate dates than what will be the formula

Very good instructions, but what if I want to highlight the entire row of the past dates? Thank you

Which formula use when due date come and than send mail automatically from excel to concern person

I'VE BEEN SEARCHING FOR THIS FOR HOURS ( AT LEAST 4S) AND IM BREATHLESS WITH THIS: =ArrayFormula( if(C2:C="";""; ifs(today()-C2:C>0;"Finish"; today()-C2:C=0; "Today"; today()-C2:C >= indirect("'Set Reminder'!A1");ABS(today()-C2:C)&" "& if(ABS(today()-C2:C) but THEN i found this video that making me feeling so dumb hahaha. Thank you so MUCH !!!!!!!!!! GREAT JOB

Empty cells are formatted too. How do I keep empty cells clean until I enter the date?

@INGLEASY

3 жыл бұрын

I had the same problem. If you go to manage rules and click on that same rule, you can edit it and change it to "no blanks". Let me know if you don't find it so I can go back to the document and get back to you (I don't have it where I'm commenting from). Good luck!

@G22865

2 жыл бұрын

@@INGLEASY ive tried editing the rule but it also highlights dates in the future. It should be anything less than today. Any advice?

If I want to Highlight the whole line not only a case ?

Any suggestions on cells that do not contain a date? I dont want them to be highlighted red if they are empty. I only want cells in the range to be highlight if there is a date available.

@trumpexcel

3 ай бұрын

That should be the default behavior with Conditional Formatting. If the cell is empty and does not have a date, it shouldn't be highlighted in any condition.

conditional formatting not available. why?

I tried to follow it but nothing happened. It didn't highlight the past due date and only highlighted blank cells. Help.

I forgot my excel file password can I reopen it???

What a surprise, it doesn't work

Interesting subject but could you please speak more slowly because your accent makes it difficult to follow.