how to highlight repeated information

[TheMightyFederer]

Greeting everyone,

Actually, I work in a company and there is around 250 employees that I’m responsible of in something. Now, my boss has given me four tables each one represents a requirement. I need to know the employees that have the four requirements.
So, I need a way that highlights the number that has been repeated four times. I know how to highlight things that have been duplicated (repeated two times).

thanks in advance,

[:) Sixthsense :)]

Please attach a sample file with expected output for getting exact and quick solution.

[FDibbins]

try using something like

=if(countif(range,criteria)>=4,"YES","NO")

[dredwolf]

without a sample hard to answer your question but maybe sothing like this in custom formatting
= IF('employeedata1'='recquirement1',IF('employeedata2'='recquirement2',IF('employeedata3'='recquirement3',IF('employeedata4'='recquirement4'))))
?

[TheMightyFederer]

Actually, I’m in the office right now where I can’t upload or even attach anything because of the internet restriction. I’ll try to attach it once I’m home.
But I’ll try to explain much more. what I was talking about is that : (for example)
I have three columns (tables). Each one of them contains around 100 cells (every cell represent an employee’s badge number). Those three tables shows employees who completed the required thing (for example “employees have driver licensee, other table employees have a car, other table employees who worked for more than five years).
So, what I need is to know the employees that have a driver licensee, have car, and worked for more than five years. If it was two tables then I can use “Highlight Cells Rules” then chose “Duplicated Values”. But in this case the tables are more than two.

So, any ideas???
By the way, I tried these things that you gave me but it didn’t work. (maybe I didn’t know how to do it but I need you to specify the way)

[TheMightyFederer]

here is a sample that i worked out.
the tables represent a single requirement while the numbers represent employees' badge numbers.

what i need is that i want to highlight every badge number has been repeated in the three tables.
just as what i have done in the second sheet.

thanks in advance... waiting for your response...

[dredwolf]

sorry, just got home from work, will look at it right away, 1 question..do you want the badge # highlighted in first cell only, or all 3 cells?

[dredwolf]

okay, have done what i think you are looking for, i used conditional formatting for the highlighting(light green), in column f the formula i used to for the first column highlighting also gives a true/false answer to the (unasked ) question of if the employee is in all three columns

[TheMightyFederer]

that's just great... that's excactly what i want...

but the question now is how is it possible to do it???

now you have done it with three tables, what about if i want to do it with four, five, or six???

and what about if i want to highlight only the first cell (although that i wanted to highlight all three cells in the first place but since you asked, then tell me how if it is possible)...

really really greatfull...

[dredwolf]

the formula I used in the "F" column is expandable, just add ',MATCH($A2,E:E,0)'for each new requirement, changing the E:E to where ever your data lists are and changing the >=2 to whatever number of matches required (2 in this case becaue the first column does not need to be counted,it is the source of the matches, so already exists ), then use variations of the final formula in the conditional formatting rules as i have done in the sample

hope that helps

-EDIT-

just a quick note, in the example, the formula in the 'F" column does NOT do any of the highligting, i left it there to show the general idea of HOW to come up with a formula to meet the requirements, the actual highlighting takes place in the conditional formatting rules.

-EDIT 2-

sorry,I just re-read your reply, the way to only highlight the first cell is to remove the highlighting rules for the 2nd and 3rd columns, same applies to only highlighting secon cell, remove highlighting rules for first and 3rd columns, etc..

-Edit 3-
sorry, i have just woke up, seems I need more coffee yet..
the "how to do it " is porbably easier to watch than explain, if you select cell 'F2', click the Formulas tab, click Evaluate formula, then hit the evaluate button, you can watch a step-by-step breakdown of how the formula arrives at its answer.
to do the same for a result that is true, select a cell with 'True' in it, 'F37' for example and repeat above steps

basicall, it checks to see if the data in column1, is in column 2, counts it if it is, repeats for column 3, then if the count is 2, the value in column 1 has to be in all 3 columns

hope that helps