Change fields background color after data entry

[Joe]

I would like to have the field on my date entry form change to a specfic
color after data is entered. Right now all the fields background are white. I
would like them to be light green, for example after data is entered and
saved.

Can this be done without me know how to write codes? Is there a simple
code/script that I can copy and use to make this happen?

Thanks.

 

[Jeanette Cunningham]

Joe,
you can use conditional formatting to do this.
Look on the format menu | Conditional formatting.


Jeanette Cunningham -- Melbourne Victoria Australia

 

[Darrell Childress]

The easiest way is to use Conditional Formatting - Format, Conditional
Formatting.
Then change the dropdown box to "Expression Is" and type in MyField is
Null and then choose your desired formatting.
Darrell

 

[Joe]

Thank you, Jeanette.

Joe,
you can use conditional formatting to do this.
Look on the format menu | Conditional formatting.


Jeanette Cunningham -- Melbourne Victoria Australia

 

[Joe]

Thanks for your response, Darrell.

The easiest way is to use Conditional Formatting - Format, Conditional
Formatting.
Then change the dropdown box to "Expression Is" and type in MyField is
Null and then choose your desired formatting.
Darrell