Conditional Formatting Rows

K

kimmy2003

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.
 
T

T. Valko

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 Format>Conditional Formatting
Formula Is: =$P1="sold"
Click the Format button
Select the style(s) desired
OK out

Biff
 
Top