Fill in the format according to the top line line code

[Excelpromax123]

Hello forum members. I want to color in a format according to a row code representing the top row. My file codes are sorted from the largest number and together and decreasing to 0 (Example from 99 to 0 ). thank you

Loading Google Sheets

 

[Alex Blakenburg]

Do you mean conditional formatting like this ?

Colos.xlsx
	D	E	F	G	H
1
2
3
4	no	x1	x2	x3	x4
5	99	A1	1	2	3
6	99	A2	1	2	3
7	99	A3	1	2	3
8	98	A4	1	2	3
9	98	A5	1	2	3
10	98	A6	1	2	3
11	98	A7	1	2	3
12	98	A8	1	2	3
13	97	A9	1	2	3
14	97	A10	1	2	3
15	97	A11	1	2	3
16	97	A12	1	2	3
17	97	A13	1	2	3
18	97	A14	1	2	3
19	96	A15	1	2	3
20	96	A15	1	2	3
21	96	A15	1	2	3
22	96	A15	1	2	3
23	96	A15	1	2	3
24	96	A15	1	2	3
25	96	A15	1	2	3
26	96	A15	1	2	3
27	96	A15	1	2	3
28	95	A15	1	2	3
29	95	A25	1	2	3
30	95	A26	1	2	3
31	95	A27	1	2	3
32	95	A28	1	2	3
33	95	A29	1	2	3
34	95	A30	1	2	3
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D5:H34	Expression	=$D5<>$D4	text	NO

 

[Excelpromax123]

Do you mean conditional formatting like this ?

View attachment 80640

Colos.xlsx
	D	E	F	G	H
1
2
3
4	no	x1	x2	x3	x4
5	99	A1	1	2	3
6	99	A2	1	2	3
7	99	A3	1	2	3
8	98	A4	1	2	3
9	98	A5	1	2	3
10	98	A6	1	2	3
11	98	A7	1	2	3
12	98	A8	1	2	3
13	97	A9	1	2	3
14	97	A10	1	2	3
15	97	A11	1	2	3
16	97	A12	1	2	3
17	97	A13	1	2	3
18	97	A14	1	2	3
19	96	A15	1	2	3
20	96	A15	1	2	3
21	96	A15	1	2	3
22	96	A15	1	2	3
23	96	A15	1	2	3
24	96	A15	1	2	3
25	96	A15	1	2	3
26	96	A15	1	2	3
27	96	A15	1	2	3
28	95	A15	1	2	3
29	95	A25	1	2	3
30	95	A26	1	2	3
31	95	A27	1	2	3
32	95	A28	1	2	3
33	95	A29	1	2	3
34	95	A30	1	2	3
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D5:H34	Expression	=$D5<>$D4	text	NO

Thank You !

 

[Alex Blakenburg]

You’re welcome.