Automatically Hide Rows based on Formula driven Cell Value

[AKMAKM]

I want to automatically hide/unhide rows/content when I select certain value in a specified cell.

I have two values in cell (C21) formula based, changing automatically when the value change in cell (B5) in sheet named (REPORT CARD)

The values of (C21) is 900 and 1000

Im trying to Clear or Hide the values and text in Row "18" if the value of (C21)= 900 and unhide (text and furomulas) in Row "18" when the value (C21)= 1000.

Appreciate any help at all, thanks in advance!

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

Cell Formulas
Range	Formula
B4	B4	=IFERROR(INDEX('Student Database'!$B$2:$B$134,MATCH('Report Card'!B5,'Student Database'!$C$2:$C$134,0)),"")
G4	G4	=IFERROR(INDEX('Student Database'!$E$2:$E$134,MATCH('Report Card'!B5,'Student Database'!$C$2:$C$134,0)),"")
G5	G5	=IFERROR(INDEX('Student Database'!$D$2:$D$134,MATCH('Report Card'!B5,'Student Database'!$C$2:$C$134,0)),"")
C7	C7	=J4
I10:I18	I10	=C10+D10+E10+F10+G10+H10
C21	C21	=VLOOKUP($G$5,'Class & Marks setting'!A2:B14,2,FALSE)

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

Cells with Data Validation
Cell	Allow	Criteria
B5:D5	List	=OFFSET('Student Database'!$C$2,,,COUNTA('Student Database'!$C$2:$C$134))

Report Card.xlsm
	A	B
1	Class	Marks out of
2	Boys 01	900
3	Boys 02	900
4	Boys 03	900
5	Girls 01	900
6	Girls 02	900
7	Girls 03	900
8	4	1000
9	5	1000
10	6	1000
11	7	1000
12	8	1000
13	9	1000
14	10	1000
Class & Marks setting

Report Card.xlsm
	A	B	C	D	E	F	G
1	Sr.#	Roll No.	Student Name	Class	ID Number	Contact No.	Address
2	1	1001	Test 1	Boys 01	198365391	(44) 211-9093	224-KAD IN ROLL
3	2	1002	Test 2	Boys 02	198365381	(44) 211-9083	223-KAD IN ROLL
4	3	1003	Test 3	Boys 03	198365371	(44) 211-9073	222-KAD IN ROLL
5	4	1004	Test 4	Giarls 01	198365361	(44) 211-9063	221-KAD IN ROLL
6	5	1005	Test 5	Giarls 02	198365351	(44) 211-9053	224-KAD IN ROLL
7	6	1006	Test 6	Giarls 03	198365341	(44) 211-9043	223-KAD IN ROLL
8	7	1007	Test 7	1	198365331	(44) 211-9033	222-KAD IN ROLL
9	8	1008	Test 8	2	198365321	(44) 211-9023	221-KAD IN ROLL
10	9	1009	Test 9	3	198365311	(44) 211-9013	224-KAD IN ROLL
11	10	1010	Test 10	4	198365301	(44) 211-9003	223-KAD IN ROLL
12	11	1011	Test 11	5	198365291	(44) 211-8993	224-KAD IN ROLL
13	12	1012	Test 12	6	198365281	(44) 211-8983	223-KAD IN ROLL
14	13	1013	Test 13	7	198365271	(44) 211-8973	222-KAD IN ROLL
15	14	1014	Test 14	8	198365261	(44) 211-8963	221-KAD IN ROLL
16	15	1015	Test 15	9	198365251	(44) 211-8953	224-KAD IN ROLL
17	16	1016	Test 16	10	198365241	(44) 211-8943	223-KAD IN ROLL
18	17
Student Database

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:G134	Expression	=$J$4=ROW()	text	NO

 

[mumps]

Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for the sheet with the formula in cell C21 and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet.

Private Sub Worksheet_Calculate()
    Select Case Range("C21").Value
        Case Is = 900
            Rows(18).Hidden = True
        Case Is = 1000
            Rows(18).Hidden = False
    End Select
End Sub