I have an excel file which shows readings of oil change.
I want to highlight the week numbers when Oil date is due as per total running hours (cell G2).
The formula or conditional formatting should highlight week in which oil is replaced and next change is due. For example: if oil is changes in june last week, it should highlight june 4th week and it should calculate next change date and highlight respective week.
NEED HELP PLEASE
Attached is sample sheet
Bookmarks