if / maintain value

[mekhallet salah]

Hello sir i have two questions if you may. 1st : cell A1 for exemple = B2 IF it is background is colored . 2nd i have this table that contained conditioning formating color if thé student present counte as thé session is paid. And add it to how much sessions is paid . M'y question is some students are there for one Time si i need to delete it but with no change in thé total. Just to leave Space and dont have a crowded sheet . Thankyou