# conditional format with conditons

1. ## 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!

2. ## Re: conditional format with conditons

I've some questions:

3. ## Re: conditional format with conditons

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?

4. ## Re: conditional format with conditons

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.

5. ## Re: conditional format with conditons

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.`

6. ## Re: conditional format with conditons

let me just try to clarify. pretty obvious that im not an excel expert so please bear with me...

my data is a bunch of rows of ID # along with various data points in the next few columns.
i am trying to find any ID # in Column A that has an entry in both Column C and D (Value 1 and Value 2) throughout any of the rows. In the sample I attached, only 1180 (A5:6) and 1185 (A12) have an entry in both Column C and D (C6 & D5 for "1180" and C12:D12 for "1185)

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

i hope this clarifies a bit

thanks!

7. ## Re: conditional format with conditons

perfect! thanks!

8. ## Re: conditional format with conditons

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.

9. ## Re: conditional format with conditons

You are welcome, thanks for the rep .

10. Originally Posted by HansDouwe
My formula in Post #5 does not highlight 1184.
I was referring to Crooza's answer. Your's worked great.
Sorry for the misunderstandings

11. ## Re: conditional format with conditons

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

There are currently 1 users browsing this thread. (0 members and 1 guests)