conditional formatting with criteria

[excel wannabe PP]

i have this table:

2022-101	101	1
2022-pzl	101		1
2020-201	102	1
2020-202	103	1	1
101	102	103

i want to conditional format Row 6 if the matching value in column b (ex. 101) is populated in column c and d even if on different rows. (ie: 101 yes,102 no, 103 yes).
i have this - =COUNTIFS(b1:b4,c6,c1:c4,">0",d1:d4">0") which applies to "103". however i cant figure out how to have it look in different rows also to apply to "101" also.

thanks. i hope its clear enough

 

[excel wannabe PP]

i have this table:

2022-101	101	1
2022-pzl	101		1
2020-201	102	1
2020-202	103	1	1
101	102	103

i want to conditional format Row 6 if the matching value in column b (ex. 101) is populated in column c and d even if on different rows. (ie: 101 yes,102 no, 103 yes).
i have this - =COUNTIFS(b1:b4,c6,c1:c4,">0",d1:d4">0") which applies to "103". however i cant figure out how to have it look in different rows also to apply to "101" also.

thanks. i hope its clear enough

Got it solved. Didn't ask the question clearly anyways

 

[Peter_SSs]

Good to hear you got the solution.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.