Dec 19 2019 01:14 PM
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
Dec 19 2019 06:30 PM - edited Dec 19 2019 06:37 PM
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 )8)
If this answer was the best response please click the button
I also happily accept likes :grinning_face:
Dec 27 2019 09:35 AM
@Wyn Hopkins
It is not working.
I need the Max and Min value for every column for everyday.