I've been working away at this problem for a few hours this afternoon to no avail. I am trying to make an
excel sheet to help calculate student grades, with a few specific requirements.
I have a column of numbers from
G4 to G19. 5 numbers in Total top 4 numbers are 3 cells merged together. I am able to use conditional formating equal to
using =max($G$4:$G$19) then format green, this fills the cell with the highest number in that cell green, which is fine.
Now within that there are 3 numbers in a column to the right that are associated with that specific highest number.
For example, lets say merged cell G10 (composed of G10 to G12) has 3 numbers to the right of it in I10, I11, I12, I want to
also fill the color in for the highest of those 3 numbers, but only if G10 is the highest number in its column first.
I will attach an example, currently level 2 which has 7 results is highlighted as meeting the conditional format for
highest number in column G, what I want to now be highlighted as a result of that response is I11 which has the highest
number out of I10 to I12.
There are levels 4, 3, 2, 1, R, M within those there are 3 sub levels.
Essentially they have a mark pool in yellow. How I am to calculate marks is count all of the 2's for example including, 2+,
2, 2- if there are more 2's than other numbers then they get a 2 grade, however, I now need to know which they got more of
within the 2's be it 2+, 2, or 2-. I want to highlight which level they got more of (in this case they had 7 2's) but also
want to highlight within the 2's which they got more of (in this case 2) however, I need that result (5 in this case) to be
Your help is appreciated