want whole row to shade gray when drop down item in row = "completed"

[hrlady]

Hello,
I am a newbie to this forum. It seems that this would be relatively simple to do, but I cannot figure out how to make it happen so your help is appreciated.
I have a a worksheet with a drop down menu in one column to show various completion status options (Not started, In progress and Completed). I was able to use conditional formatting to change the color of the cell to gray when I choose "completed" from the drop down menu, but I would like the whole row in view (about 8 cells across) to shade to gray when I choose "completed" from the drop down - not just the completed cell. I'm thinking an IF statement would work, but I don't know how to use an IF statement to shade a range of cells a color. Ideas?
Thank you!

-inept hrlady

[NBVC]

Select all the rows and then invoke Conditional Formatting

Choose Formula Is from the 1st dropdown menu and enter formula

=$A1="Completed"

where A1 is the topmost cell in the selection of rows that contain the drop down list to check on.

then continue to choose colour.

[hrlady]

Excellent.
Thank you!

[NBVC]

You are welcome,

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save