Formatting Based on Drop-Down

[bpcstaff]

I have a database of companies with a dropdown field ("Status") that lists their membership status as Active or Inactive.

I'd like to conditionally format so that the "Company" field goes grey when the user selects Inactive from "Status".

My mind's drawing a blank, here - any help appreciated!

[Fitch]

Conditional formatting is not available in FileMaker 8.5. Is your profile up to date?

You can achieve the same effect in earlier versions by using a calculated field, e.g.:

Case( Status = "Inactive" ; Company )

And then overlay this field (formatted in gray) on top of the actual Company field.

[bpcstaff]

Thanks, Fitch!