conditional format with conditons

i have this table:

sample 376.xlsx

i want to conditional format column f if the matching value in column a (ex. 1180) is populated in column c and d even if on different rows..

i have this - =COUNTIFS(a1:a14,f2,c1:c14,">0",d1:d14">0") which applies to "1185". however i cant figure out how to have it look in different rows also to apply to "1180" also.


Thanks!

I've some questions:

I'm wasting my time. I'm figuring out what you want and meanwhile you're changing the example and question in Post #1.

But I don't really understand the new situation either.
I do not see 1180 and 1185 in column C and in column D.
So why do they need to be marked anyway?

Use this conditional format formula and apply to F2 to F12

=SUMPRODUCT(--(F2=$A$2:$A$14)*IF($C$2:$C$14<>"",1,0)+--(F2=$A$2:$A$14)*IF($D$2:$D$14<>"",1,0))= 2

Spreadsheet attached and I've shown the formula in column H to explain what it is doing in each instance.

In the meantime I also understand what the intention is.

Please try this CF-rule appy to $F$2:$F$12:

Formula:

=SUMIF(A$2:A$14,F2,C$2:C$14)*SUMIF(A$2:A$14,F2,D$2:D$14)>0

The formula you made also highlights "1184" although it doesnt have an entry in Column D.

My formula in Post #5 does not highlight 1184.

You are welcome, thanks for the rep .

In that case please start the post with @Crooza, especially in case you don't refer to the previous post.