Duplicate Formatting

[RT]

Hello Everyone.

I have this FM 10

i have a portal with 35 rows, i have to enter dates into one field i have a button that duplicates these dates then i go back and enter my Dates.

I would like to do this.

If i have the same date twice i would like it to turn RED with conditional formatting. how do i do it.

: :qwery:

[RT]

i found an answer thanks to Chopper.

http://starrdata.com/downloads.htm

Duplicate Data Across Multiple Fields

Using custom formatting you can now capture duplicate data across multiple fields on the same record. If there are 2 or more duplicate fields, the conditional format calculation kicks in to alert the user by changing the background color to red.

Revision 2 added thanks to suggestion from raybuadi of FMForums

In this sample you must have FileMaker 9.0 ore higher.