Conditional Formatting based on another field's data?
Is it possible to set a field's conditional formatting based on the data in another field?
WHAT I'M TRYING TO DO:
I have a trainer's roster database with a field entitled "STATUS" which uses a value list for its contents. All I want to do is have the trainer's name field go to a different color whenever their status is set to "Inactive".
It seems pretty straight forward, but I don't seem to be able to get the formula right. Is that even possible?