In layout mode select all the fields that you want to show a different fill color when field 1 contains data.
Select conditional format, click add and select the formula option.
Enter this expression:
Not Isempty (yourtable::yourfield1name)
Click Ok and select a fill color from the bottom of the conditional format dialog and click OK.
Thanks for your input.
I have added this formular. No the 5 fields are red, but then i put some data in the first field they are still red. I think i need something in the formular who say if where is something in the 5 files the should be white again.
IsEmpty ( Self ) and not IsEmpty ( YourTable::Field1 )
I have a related question.
Lets say you have six fields and you want all six of the fields to be red until data has been entered in all six fields. What would the formula be for that?
IsEmpty ( Field1 ) or IsEmpty ( Field2 ) or ... IsEmpty ( Field6 )