excel_1317
Board Regular
- Joined
- Jun 28, 2010
- Messages
- 212
I have students data with their %marks in each Subject. I have applied conditional formatting on the basis os marks percentage. eg: Green if Marks is above 80 %, Yellow is marks in between 40% to 60%, Red if marks ia below 40%.
Now in first column, there is students names. I want if i have total of 6 subjects, student having 5 or 6 green subjects should turn the name in Green, Student having 3 or 4 Green subjects, should turn his name Yellow
and lastly, 1 or 2 subjects Green, should turn student name into RED...
Is this something achievable?
Now in first column, there is students names. I want if i have total of 6 subjects, student having 5 or 6 green subjects should turn the name in Green, Student having 3 or 4 Green subjects, should turn his name Yellow
and lastly, 1 or 2 subjects Green, should turn student name into RED...
Is this something achievable?