I would like assistance with some conditional formatting.
What I would like to achieve is to highlight a cell dependant on a set criteria.
Screen Shot 2017-12-15 at 13.43.14.png
As you can see from the attached I would like to highlight the highest value in column H based on the Load Group selection (column D)
For example.... I would like the cell that contains the value of "32" to be highlighted as the highest value for Load Group "D. Motors"
Thanks in advance.
Bookmarks