Threshold Alert in Excel to Highlight Expiration Dates | Conditional Formatting | Today Formula

[@mustafaali5129]

I have been trying to find a video on this topic, and you explained it so beautifully. Thank you

[@SamuelGhigiarelli]

Great video!

[@analopes-barbosa4084]

Otimo video Jopa!

[@Dave-gg6vl]

Thank you helped me a lot and I was able to adapt it to what I needed

[@caroltanzola5966]

Good job Jopa!

[@carolinaforbes5020]

hi!thanks for this video.this is the closest to what i am looking for. .. what if it is a monthly rental with overdue date so i can easily see if i'm about to disconnect the service and i can have it colored green for not overdue yellow for not fully paid and red for overdue already. then, i can copy the formula every month just to update it monthly..thanks very much!looking forward to your next video about this...

[@2007dodi]

If I only have the certificate issuing date but I want to know the expire date - how to do that? as the certification expired every 3 years - can you help ?

[@hassanhanif8287]

Make a column/row for expiry date and write "=issue date+1095" u will find expiry date, now drag it to all length of column/row.

[@AliRaza-wp8tr]

Thanx

[@louisenoesgaard3208]

When i do it my Excel comes up with a Warning at the end. Saying the formular have a mistake. Needing the apostrophe?

[@nghueychyn603]

I have followed the tutorial but only manage to get red highlight (expired item) but unable to display yellow highlight for those nearby expired items 😢

[@ranarayya1724]

WOW