You could use conditional formatting to do this (available on the
Format menu).

What do you class as "Other ineligible data"?

Pete

On Jan 28, 5:10*pm, Maggie wrote:
Hi,

I have a worksheet that various people work on and I would like for
the row to highlight yellow when someone enters Paid Off and red when
Missing. *I also would like for the row to highlight red when Other
ineligible data is entered into the row. *Please help.

thanks