Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have 4 columns A-D, i want to do a conditional design for couples for all the columns together.

    A B C D
    1 2 3 4
    1 3 4 5
    1 2 3 4

In this example rows 1 and 3 will marked but not row 2 because column D is not the same. How can i do this?

share|improve this question

migrated from stackoverflow.com Mar 25 '11 at 11:00

This question came from our site for professional and enthusiast programmers.

    
this makes no sense - "row...3 will marked but not row 3" –  Jody Mar 26 '11 at 16:19
    
oh, sorry, i fixed it... –  aharon Mar 27 '11 at 13:26
    
just to be clear... if a row has, for example, "4" in column D, the entire row gets marked? What you want is probably something like this. Using just the first row, conditional format D1 so that if it = 4, it's formatted. Then for cells A1,B1,C1, choose conditional format, dropdown to Formula Is, then have something like =$D1>3 (if D1 is greater than 3, apply formatting) –  CreeDorofl Mar 27 '11 at 15:41
    
i want that all the columns A-D would be similar and then it would marked. –  aharon Mar 31 '11 at 20:08

1 Answer 1

up vote 0 down vote accepted

Well, if you want to see all rows that have more than 1 occurrence, you can do something like this... Add a column with (column E)

=CONCATENATE(A2,B2,C2,D2)  

then next to that

=COUNTIF($E$2:$E$4,E2) 

Make sure to include the absolute references for the countif. Then any row that is >1 means there is another duplicate row somewhere in the list. Hope that's what you're looking for.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.