Clear Cell Based on Another Cell Value

[AKMAKM]

I have two values in cell (C19) changing automatically when the value change in cell ( G2) in sheet named (REPORT CARD)

The values of (C19) is 900 and 1000

Im trying to Clear a value and text in "A16:J16" if the value of Cell (C19)= 900 and bring it back (text and furomulas) as before in "A16:J16" when the value (C19)= 1000.

I need your help to provide me a VBA code for clear the values as stated, also if any possible, I need the code if I want to delete the Row instead and bring it back (with text and furomulas) as before

Thanks alot

Book1
	A	B	C	D	E	F	G	H	I	J
1	Roll No.				ID Number				Term	Term 2
2	Student Name				Class				Year	2021
3
4	Subjects		Term 2
5			Class room participat-ion	Pop up quizzes	Homework	Midterm Exam	Projects & Researches	Final Exam	SCORE	Grade
6			20	10	15	15	10	30
7	Technology								0
8	Language Arts								0
9	English								0
10	Mathematics								0
11	Science								0
12	Social Studies								0
13	Computer								0
14	Art								0
15	French								0
16	Health and Safety								0
17
18	TOTAL MARKS			GRADE				POSITION
19	OUT OF							OUT OF
REPORT CARD

Cell Formulas
Range	Formula
C4	C4	=J1
I7:I16	I7	=C7+D7+E7+F7+G7+H7

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
J7:J16	Cell Value	top 10% values	text	NO
J7:J16	Other Type	Color scale		NO

 

[bebo021999]

Instead of deleting row, how about hide/unhide row according to C19?

 

[AKMAKM]

Yeah It's Fine

 

[bebo021999]

Is cell C19 manual input value or formula?

 

[AKMAKM]

It is formula in relation with Class cell (G2)
=VLOOKUP($H$17,Class!B9:C21,2,FALSE)

For more clarification, I have 2 student class (Grade 1 & Grade2), occupied the cell (G2).
If the class name changed (G2) from Grade 1 to Grade 2, then the cell of (out of): (C19) will be changed automatically from 900 to 1000
Grade 1 = 900 Mark
Grade 2 = 1000 mark

Hence, I want to hide/unhide row according to output of C19.