RT Posted September 9, 2009 Share Posted September 9, 2009 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: Link to comment Share on other sites More sharing options...
RT Posted September 26, 2009 Author Share Posted September 26, 2009 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5332 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now