AnsweredAssumed Answered

Two Tricky Conditional Formatting Questions

Question asked by JoshHyman on Mar 11, 2011
Latest reply on Mar 17, 2011 by JoshHyman

Title

Two Tricky Conditional Formatting Questions

Post

Hi There,

I need some help on a few conditional formatting issues that I have.

1. Is there a way to add conditional formatting to a range of cells without deleting (overriding) the current conditional formatiing of a field.

Basically I have a Formula based "self" referncing and I want to apply it to a range of fields, some of these fields already have other formulas that I would rather not recreate.

2. This one is a bit harder. Many of my fields have data valadtion form a few different related values value lists. As this list dynamically updates I want a conditional formula, or script for that matter to tell me when a field that has had data entered into from the list, is no longer available in that list.

For example

1. The field Shows::Rope Circle, has the choices from a related values value list of ..... John, Fred, Tom, Sam.

2. I enter sam in this field

3. Sam calls in sick and is removed from the related value list

4. I filemaker to tell me that Sam is no longer a valid choice for this field.

Doews anyone know if this is possible?

Thanks for your help.

J

Outcomes