Conditional Formatting Rows
 

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.

Conditional Formatting Rows
 

Try this:

Assume your range of data is A1:P10

P1:P10 may or may not contain "sold".

Select the range A1:P10
Goto the menu FormatConditional Formatting
Formula Is: =$P1="sold"
Click the Format button
Select the style(s) desired
OK out

Biff

"kimmy2003" wrote in message
...
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.