Forum Discussion
Conditional format - Highlight Max and Min value for a group of rows
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
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
Hope that helps
Wyn
MVP
Australia (UTC + 8 )😎
If this answer was the best response please click the button
I also happily accept likes 😀
Wyn Hopkins
It is not working.
I need the Max and Min value for every column for everyday.
