Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-1075028%22%20slang%3D%22en-US%22%3EConditional%20format%20-%20Highlight%20Max%20and%20Min%20value%20for%20a%20group%20of%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1075028%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20highlight%20the%20max%20and%20min%20value%20for%20every%20column%20for%20each%20group%20of%20rows%20that%20referred%20to%20the%20same%20day.%3CBR%20%2F%3ERows%205%20-%2012%20as%20a%20group%2C%20I%20need%20to%20highlight%20the%20Max%20and%20Min%26nbsp%3B%20value%20with%20different%20colors%20for%20each%20column%20(W1%2CX1%2CY1%2C...)%26nbsp%3B%3C%2FP%3E%3CP%3Esame%20thing%20for%20the%20group%2013-%2033%3CBR%20%2F%3Euntil%20the%20last%20rows%3CBR%20%2F%3EPlease%20find%20the%20file%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1075028%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1075420%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20format%20-%20Highlight%20Max%20and%20Min%20value%20for%20a%20group%20of%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1075420%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F87534%22%20target%3D%22_blank%22%3E%40Jihad%20Al-Jarady%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20makes%20your%20file%20pretty%20slow%20as%20there's%20a%20lot%20of%20calcs%20going%20on%20but%20see%20if%20this%20works%20(File%20attached)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20added%20a%20helper%20column%20to%20just%20give%20the%20date%20rather%20than%20date%20and%20time%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F162668i18C3D7F4DD23C5C0%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EHope%20that%20helps%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EWyn%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EMVP%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EAustralia%20(UTC%20%2B%208%20)8)%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%3CSPAN%20style%3D%22font-style%3A%20italic%3B%22%3EIf%20this%20answer%20was%20the%20best%20response%20please%20click%20the%20button%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-size%3A%2011.0pt%3B%22%3E%3CSPAN%20style%3D%22font-style%3A%20italic%3B%20font-family%3A%20Calibri%3B%22%3EI%20also%20happily%20accept%20likes%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20'Segoe%20UI%20Emoji'%3B%22%3E%3Agrinning_face%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20'Segoe%20UI%20Emoji'%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorclipboard_image_1%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%20id%3D%22tinyMceEditorclipboard_image_2%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1081850%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20format%20-%20Highlight%20Max%20and%20Min%20value%20for%20a%20group%20of%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1081850%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EIt%20is%20not%20working.%3CBR%20%2F%3EI%20need%20the%20Max%20and%20Min%20value%20for%20every%20column%20for%20everyday.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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
Highlighted

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 )

 

If this answer was the best response please click the button

I also happily accept likes

 

 
 

 

Highlighted

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