Complex Conditional formatting

[Benbenken]

I have a conditional formatting set that if the value of a cell in H is <30 the row is red.
I would like to make it that if a cell in A is red, than all duplicate values of that red cell in A and its row are also red. What would be the formula to do this if there is one?

 

[Snakehips]

@Benbenken Welcome.

With range edited to suit, maybe like below.

MrExcelAug.xlsx
	A	B	C	D	E	F	G	H	I	J
1
2	XX							44
3	aa							32
4	cc							32
5	bb							32
6	XX							32
7	gg							32
8	gg							32
9	qw							32
10	qw							32
11	qw							32
12	qqqq							28
13	qw							32
14	qw							32
15	XX							29
16	XX							32
17	XX							32
18	XX							32
19	XX							32
20	ac							44
21	jjjjjj							44
22	jjjjjj							3
23	ac							44
24
25
26
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
2:999	Expression	=COUNTIFS($A$2:$A$999,"<>""",$A$2:$A$999,$A2,$H$2:$H$999,"<30")>0	text	NO

Hope that helps.

 

[Benbenken]

@Benbenken Welcome.

With range edited to suit, maybe like below.

MrExcelAug.xlsx
	A	B	C	D	E	F	G	H	I	J
1
2	XX							44
3	aa							32
4	cc							32
5	bb							32
6	XX							32
7	gg							32
8	gg							32
9	qw							32
10	qw							32
11	qw							32
12	qqqq							28
13	qw							32
14	qw							32
15	XX							29
16	XX							32
17	XX							32
18	XX							32
19	XX							32
20	ac							44
21	jjjjjj							44
22	jjjjjj							3
23	ac							44
24
25
26
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
2:999	Expression	=COUNTIFS($A$2:$A$999,"<>""",$A$2:$A$999,$A2,$H$2:$H$999,"<30")>0	text	NO

Hope that helps.

Yes, but I would like it to change even if the value of the H cell is >30 if there is a duplicate in A where that row is <30
Similar to the pic below

 

[Snakehips]

Surely, that is exactly what my suggestion is doing?

MrExcelAug.xlsx
	A	B	C	D	E	F	G	H
1
2	XX							54
3	GG							180
4	jj							5
5	FFF							60
6	PPP							122
7	XX							76
8	XX							54
9	GG							95
10	GG							159
11	FFF							62
12	jj							78
13	jj							19
14	XX							14
15	PPP							31
16	GG							85
17
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
2:999	Expression	=COUNTIFS($A$2:$A$999,"<>""",$A$2:$A$999,$A2,$H$2:$H$999,"<30")>0	text	NO

 

[Benbenken]

Yes! This worked perfectly! Thank you!