Excel Forum

Recurring Monthly Due Date

David

Member

Members

Forum Posts: 13

Member Since:
April 18, 2020

Offline

April 18, 2020 - 1:08 pm

Hello,

I am trying to set a recurring date that our tire pressures are due for our maint. vehicles. Column F I need the date to be the 10th day of each month until Column E is updated. Column E I need some condition formatting for when the day gets closer to the 10th day of the current month. Truck Type 1 dates I need to turn yellow on the 1st - 3rd days and red until updated. Truck type#2 I need to turn yellow 4th-5th day and red until updated. Truck type 3&4 yellow on the 6th-8th day and red until updated. Attached I have the worksheet to help better understand my jargon.

Thank you all that help,

David

See Answer

Purfleet

England

Member

Members

Trusted Members

Forum Posts: 415

Member Since:
December 20, 2019

Offline

April 19, 2020 - 3:14 am

Hello David

Please see the attached.

I have updated the formula in column F to be relative to todays date as it seems a bit more reliable (feel free to use your own if you prefer). And then added in the condictional formating that you asked for.