Conditional format - Highlight Max and Min value for a group of rows

Steel Contributor

I need to highlight the max and min value for every column for each group of rows that referred to the same day.
Rows 5 - 12 as a group, I need to highlight the Max and Min  value with different colors for each column (W1,X1,Y1,...) 

same thing for the group 13- 33
until the last rows
Please find the file attached

2 Replies

Hi @Jihad Al-Jarady 

 

It makes your file pretty slow as there's a lot of calcs going on but see if this works (File attached)

 

I added a helper column to just give the date rather than date and time

 

clipboard_image_0.png

 

Hope that helps

 

Wyn

MVP

Australia (UTC + 8 )8)

 

If this answer was the best response please click the button

I also happily accept likes :grinning_face:

 

 
 

 

@Wyn Hopkins 
It is not working.
I need the Max and Min value for every column for everyday.