How will I colour same data with conditional formatting?

[melal]

Hello,

I am new on File Maker. I'm using FM11 Pro.

I want to learn how will I colour same date with conditional formatting?

Thanks.

[comment]

Same date as what?

[melal]

I have a teams text field.

All I want to do is if the data on the teams text field are the same

I want to give the same colour to the same teams.

Ttanks.

[comment]

Sorry, I don't follow. Please provide a more detailed explanation, perhaps with an example.

[melal]

Example

I have a list of people, years and holiday destinations.

For example, Person A went to Italy in 2008 and 2011. I want to make "conditional formatting" to the same Italy fields in the table.

I want duplicate or more results to be highlighted in the list.

[comment]

I'm still not sure I understand this, but I will take a shot: define a self-join of your table, matching on the Destination field. Base the conditional formatting on:

Count ( SelfJoin::Destination ) > 1

---

P.S. Please don't format your messages so - I can't read such a small font.

[melal]

I have tried the solution you have recommended, but unfortunately it didn't work. I want to highlight the same names (the names that exist in the same table for more than one time) in the table with "conditional formatting" feature how can I do that?

[comment]

Does this work for you?

HiliteDups.zip

[melal]

it did not work.

Because when I use your formula Count ( Table 2::Category ) > 1

my match field which has 100.000 records all has gone red. But all I want to do is

conditional formatting incase of realization of two criteria at the same time.

These are same referee (in my database I have more than 2000 referees) same matches in different seasons..

Please refer to the attachment.

Thanks.

p.s If you want I can send my filemaker file.

Teams.zip

[comment]

Well, you started with "same date", changed to "the teams text field are the same", then it was "holiday destinations" and now its referees - and I still have no idea what you are looking for.