I find it better to use Conditional formatting (instead of an auto-enter calculation) on the field where you can add 3 formulae and set each to a different background and font colour. AFAIK, HighlightYellow uses only yellow.
Also depending on the actions needed try reading FMP help on .....Setting up script triggersYou can set up a script trigger to specify that a script runs when an event occurs. For example, you can use a script trigger to run a script that automatically enters data in fields based on what is entered in another field.Jim....
Sorry im quite new to FM.
Conditional formatting seems to be the way forward - thank you...