Trying to highlight the min & max values per row. Like the solution posted in
However, I only want to format PART of each row. That is, my data doesn't start in A1 and doesn't contain all columns.
For example: In data below I only want the MIN and MAX highlighted for each row (starting with r18) AND only for values in cols E:I.
E F G H I J
Row 17: Team1 Team2 Team3 Team4 MyTeam Avg Ht
Row 18: 46.8 66.0 30.8 36.6 30.0 108
Row 19: 18.2 20.0 15.4 14.6 45.0 115
I've tried several variations on the formula and just not finding it.