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

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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.