Help needed with changing colour of a row when a value is selected

[aide199]

Guys, Can anyone please help me.

I use the attached spreadsheet for work and what I need is for when I select the value of 'Held In The Depot' 'Disposed' or 'Customer Collect' from Column G I need the whole row from A to O changing to the colour that I have set up through Conditional Formatting.

So Yellow for 'Held In Depot' Red for 'Disposed' and Green for 'Customer Collect'

For the life of me I just can't work it out how I make the whole row (A to O) change to the colour determined by what I select in the drop down list I have created.

Please could someone have a look at the attached and help me out.

Thanks in advance (and I hope this makes sense)

[Fluff13]

Select A2 to end of data in column O & use this formula
=$G2="Held in the depot"

[aide199]

Select A2 to end of data in column O & use this formula
=$G2="Held in the depot"

Many Thanks for you quick reply, please excuse my 'newbie' question but do i do this through conditional formatting?

Thanks again

[Fluff13]

Yes you do, once you have selected the data in conditional formatting select New rule, then use a formula & put that formula into the box under "Format values where this formula is true", then select the format you want.

[aide199]

Yes you do, once you have selected the data in conditional formatting select New rule, then use a formula & put that formula into the box under "Format values where this formula is true", then select the format you want.

Many Thanks - I really appreciate your help

[Fluff13]

You're welcome & thanks for the feedback.