Does this field need to be filled in multiple times or just once.

If it's once, you can use conditional formatting. FOrmat - Conditional
Format.

If you want the field to be YELLOW all the time, I have a FILL COLOR BUTTON
on my formatting toolbar. You can also access it using FORMAT CELLS -
PATTERNS and select a color.

"maryann" wrote:

how do i highlight required fields, so other users will be notified that the
required cell need to be filed in?