Hello everyone
I have a sheet of students marks and in yellow columns (in my file) I need to draw red circles on the cells on condition that :
The mark is less than the mark in green cell in the same column ...In other words, if for example in cell G6 the mark is 38 and the minimum for that subject is in the green cell of the same column which is cell G5 .. so in this case I need to circle the cell G6
Another condition is the text "Absent" ,,should be also dealed like that last case and draw circle in that cell (example : cell G9)
Note I don't need to deal with all the columns (just yellow columns) and the minimum for each column existed in row 5
Hope it is clear
Thanks advanced for any help
Bookmarks