I have these spreadsheets where my reps will enter in data into each row for
a service that they pitched to a client. If the service sells, they will
choose "Sold" from a validation list in Column "P". All I want is for the
entire row to change background color when the rep selects "Sold" in that row
and not just the cell.