I have the movie database and first enter the title that should ALWAYS be entered.
For this I have a calculation field “title entered” below that queries this.
IFEMPTY (MOVIE TITLE; “NO, still missing …”; “YES, everything ok”)
This text color is red.
It should remain red if the “Title” field is empty or GREEN if the title is entered.
Can I change color of a field “title entered” with a formula or with an easier way?