Find Max in reoccurring 24hr periods

[MPFX2022]

Hi all,
I need help please.
I want to find max value in each 24hr range over a years worth of data.
So I know how to find max, conditional formatting and use an IF statement to find it for one 24hr period.
But in IF statement it needs the $ symbols to make those cells constant when I paste formula.
I want to copy/paste this formula down sheet and not have to rewrite formula each time.
I hope all that makes sense
Any help would be greatly appreciated..

 

[MPFX2022]

Here is better pic with code..

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(B2=MAX(INDEX($B$2:$B$1000,SEQUENCE(24,,INT((ROWS(C$2:C2)-1)/24)*24+1))),"Y","N")

 

[MPFX2022]

Hi & welcome to MrExcel.
How about

=IF(B2=MAX(INDEX($B$2:$B$1000,SEQUENCE(24,,INT((ROWS(C$2:C2)-1)/24)*24+1))),"Y","N")

Perfect, Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback