This content has been marked as final. Show 2 replies
Let's say your text field is named "status" and your other two fields are named "date" and "time".
- Enter layout mode and select both date and time.
- Right click one of the two and select Conditional Format.
- Use the formual option to add this expression: YourTable::Status = "Pending".
- Select the desired text color.
- Click OK.
Thanks, just what I was looking for.