Formula/Conditional formatting to highlight upcoming oil change week

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

Hi Pete,
Thanks for your reply.

Next Oil changes will be due on Reading in cell G2, Moreover, i have added some formulas to column K,L,M for better understanding and tracking. Now we have per day run in column M through which we can predict when will it reach to reading in Cell G2.
Hope you will understand it now. Thank you

Please manually add the results you expect for at least the first row of data (row 5) so that we can see what you are aiming to achieve.

As per AliGW request, i have inserted comments for achieving required results. Attached is snapshot and sample file.
Green highlighted cells shows oil change date(current) and red highlighted shows upcoming oil change week
Annotation 2022-04-30 151843.png

This proposal changes the setup, so if that isn't negotiable then please feel free to stop reading at this point.
1. The dates in row 2 are unmerged and display the first Sunday of each week using: =EOMONTH(C3,-1)+1-WEEKDAY(EOMONTH(C3,-1)+1)+1 in cell N2 and =SUM(N2,7) in cells O2:BM2
2. The week numbers in row 3 are populated using: =WEEKNUM(N2)
3. The conditional formatting rule for green is: =N$3=$C$2
4. Cells N5:BM7 are populated using: =IF(N$2<$C$3,0,SUM(M5,1)) and formatted ;;;
5. The conditional formatting rule for red is: =M5=ROUND($L5/7,0)
Let us know if you have any questions.

1. The formula in rows 5:7 is modified to read: =IF(N$2<$C$3,0,MOD(SUM(M5,1)-1,ROUND($L5/7,0))+1)
2. The rule for red is changed to read: =AND(N$2>$C$3,M5=ROUND($L5/7,0))
3. The rule for green is changed to read: =AND(N$3=$C$2,YEAR(N$2)=YEAR($C$3))
Let us know if you have any questions.

Not sure that I completely understand, but it sounds as if your boss wants the next oil change to be displayed when the value in column J reaches -145 and remain displayed until the date in cell C3 is changed.
If that is the case then the rule for red could be changed to read: =AND($J5>=-145,N$2>$C$3,M5=ROUND($L5/7,0))
Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.