How to Highlight Dates greater than 60 days old in Excel



How to Highlight Dates greater than 60 days old in Excel. Conditional format dates that are greater than 60 days old. Dates older than 60 days will be indicated
Check out my online courses
For more help visit my website or email me at easyexcelanswers@gmail.com.

I can customize this Excel application for your exact needs for a fixed price of $50. The work is normally returned within 24hrs.

Excel one-on-one on-line training available. Email me to arrange.

I am able to provide online help on your computer at a reasonable rate.

Check out my next one-hour Excel Webinar

MY videos are all created on Camtasia.

Check out Crowdcast for creating your webinars

If you need to buy Office 2019 follow

Follow me on Facebook

Follow me on twitter
easyexcelanswers

IG @barbhendersonconsulting

Follow me on Facebook

Watch more new videos about Excel Office | Synthesized by Mindovermetal English

Rate this post

Bài viết liên quan

Theo dõi
Thông báo của
guest
6 Comments
Cũ nhất
Mới nhất Được bỏ phiếu nhiều nhất
Phản hồi nội tuyến
Xem tất cả bình luận
OTITOLAIYE EMMANUEL

Thank you i love this

Ramon Gringo Agpalo

thank you very much. God bless you Barb. 🙂

Maree Carlyon

Thanks easy to follow and use.

Jena Nagamine

Thank you! This is exactly what I was looking for!

prathyusha jampani

Hi
I want to delete data from the row which is greater then the current date and it has time 12:00:00 AM

Cali Ibarra

Hi Barb, how can also add SUMIF to the above example? I have to add all "balances that are older than 30 days. Example 6/1/18 draw on 7/1/18 I have to report the outstanding principal.

In your example lets say that you have all original balances at disbursment on colum B, how can we add such balance after one month?