Conditional Formatting multiple columns based on selection made in one column

[Lesjoan01]

Hi,

I wonder if someone can help me please.

I have a spreadsheet that has a validation list in column A and then other date in columns B to I. I would like to change the colour of a row (all the data in that row) when certain 'Locations' are selected from the validation drop down list. E.G. If Leeds, Liverpool or Belfast are selected I would like the full row (A to I) to be greyed out. I have tried Conditional Formatting with formulas but I am obviously doing something wrong as it sort of works but does not colour the whole row of data (even though I pre-selected my data).

Below is what I am talking about:
[TABLE="width: 0"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[/TR]
[TR]
[TD]Location
[/TD]
[TD]Product
[/TD]
[TD]Cost
[/TD]
[TD]Quantity
[/TD]
[TD]Total Cost
[/TD]
[TD]Seller
[/TD]
[TD]Buyer
[/TD]
[TD]Re-order
[/TD]
[TD]Date
[/TD]
[/TR]
[TR]
[TD]London
[/TD]
[TD]Tea
[/TD]
[TD]£0.98
[/TD]
[TD]8
[/TD]
[TD]£7.84
[/TD]
[TD]A
[/TD]
[TD]AA
[/TD]
[TD]No
[/TD]
[TD]23/03/2018
[/TD]
[/TR]
[TR]
[TD]Liverpool
[/TD]
[TD]Coffee
[/TD]
[TD]£1.50
[/TD]
[TD]23
[/TD]
[TD]£34.50
[/TD]
[TD]B
[/TD]
[TD]BB
[/TD]
[TD]Yes
[/TD]
[TD]26/03/2018
[/TD]
[/TR]
[TR]
[TD]Manchester
[/TD]
[TD]Wine
[/TD]
[TD]£2.03
[/TD]
[TD]15
[/TD]
[TD]£30.45
[/TD]
[TD]C
[/TD]
[TD]CC
[/TD]
[TD]No
[/TD]
[TD]27/03/2018
[/TD]
[/TR]
[TR]
[TD]Edinburgh
[/TD]
[TD]Beer
[/TD]
[TD]£1.12
[/TD]
[TD]42
[/TD]
[TD]£47.04
[/TD]
[TD]D
[/TD]
[TD]DD
[/TD]
[TD]No
[/TD]
[TD]28/03/2018
[/TD]
[/TR]
[TR]
[TD]Leeds
[/TD]
[TD]Vodka
[/TD]
[TD]£6.58
[/TD]
[TD]18
[/TD]
[TD]£118.44
[/TD]
[TD]E
[/TD]
[TD]EE
[/TD]
[TD]Yes
[/TD]
[TD]29/03/2018
[/TD]
[/TR]
[TR]
[TD]Belfast
[/TD]
[TD]Gin
[/TD]
[TD]£7.00
[/TD]
[TD]25
[/TD]
[TD]£175.00
[/TD]
[TD]F
[/TD]
[TD]FF
[/TD]
[TD]Yes
[/TD]
[TD]30/03/2018
[/TD]
[/TR]
[TR]
[TD]Newcastle
[/TD]
[TD]Rum
[/TD]
[TD]£6.72
[/TD]
[TD]17
[/TD]
[TD]£114.24
[/TD]
[TD]G
[/TD]
[TD]GG
[/TD]
[TD]No
[/TD]
[TD]02/04/2018
[/TD]
[/TR]
[TR]
[TD]Liverpool
[/TD]
[TD]Wine
[/TD]
[TD]£2.03
[/TD]
[TD]20
[/TD]
[TD]£40.60
[/TD]
[TD]H
[/TD]
[TD]HH
[/TD]
[TD]No
[/TD]
[TD]03/04/2018
[/TD]
[/TR]
[TR]
[TD]Manchester
[/TD]
[TD]Beer
[/TD]
[TD]£1.12
[/TD]
[TD]52
[/TD]
[TD]£58.24
[/TD]
[TD]I
[/TD]
[TD]II
[/TD]
[TD]Yes
[/TD]
[TD]04/04/2018
[/TD]
[/TR]
[TR]
[TD]Manchester
[/TD]
[TD]Beer
[/TD]
[TD]£1.12
[/TD]
[TD]48
[/TD]
[TD]£53.76
[/TD]
[TD]J
[/TD]
[TD]JJ
[/TD]
[TD]Yes
[/TD]
[TD]05/04/2018
[/TD]
[/TR]
[TR]
[TD]Edinburgh
[/TD]
[TD]Bacardi
[/TD]
[TD]£5.99
[/TD]
[TD]17
[/TD]
[TD]£101.83
[/TD]
[TD]K
[/TD]
[TD]KK
[/TD]
[TD]Yes
[/TD]
[TD]06/04/2018
[/TD]
[/TR]
[TR]
[TD]Leeds
[/TD]
[TD]Gin
[/TD]
[TD]£7.00
[/TD]
[TD]25
[/TD]
[TD]£175.00
[/TD]
[TD]L
[/TD]
[TD]LL
[/TD]
[TD]Yes
[/TD]
[TD]09/04/2018
[/TD]
[/TR]
[TR]
[TD]Belfast
[/TD]
[TD]Gin
[/TD]
[TD]£7.00
[/TD]
[TD]32
[/TD]
[TD]£224.00
[/TD]
[TD]M
[/TD]
[TD]MM
[/TD]
[TD]Yes
[/TD]
[TD]10/04/2018
[/TD]
[/TR]
[TR]
[TD]Newcastle
[/TD]
[TD]Rum
[/TD]
[TD]£6.72
[/TD]
[TD]11
[/TD]
[TD]£73.92
[/TD]
[TD]N
[/TD]
[TD]NN
[/TD]
[TD]No
[/TD]
[TD]11/04/2018
[/TD]
[/TR]
[TR]
[TD]London
[/TD]
[TD]Tea
[/TD]
[TD]£0.98
[/TD]
[TD]22
[/TD]
[TD]£21.56
[/TD]
[TD]O
[/TD]
[TD]OO
[/TD]
[TD]No
[/TD]
[TD]12/04/2018
[/TD]
[/TR]
[TR]
[TD]Liverpool
[/TD]
[TD]Coffee
[/TD]
[TD]£1.50
[/TD]
[TD]15
[/TD]
[TD]£22.50
[/TD]
[TD]P
[/TD]
[TD]PP
[/TD]
[TD]No
[/TD]
[TD]13/04/2018
[/TD]
[/TR]
[TR]
[TD]Manchester
[/TD]
[TD]Coffee
[/TD]
[TD]£1.50
[/TD]
[TD]20
[/TD]
[TD]£30.00
[/TD]
[TD]Q
[/TD]
[TD]QQ
[/TD]
[TD]Yes
[/TD]
[TD]16/04/2018
[/TD]
[/TR]
[TR]
[TD]Edinburgh
[/TD]
[TD]Bacardi
[/TD]
[TD]£5.99
[/TD]
[TD]14
[/TD]
[TD]£83.86
[/TD]
[TD]R
[/TD]
[TD]RR
[/TD]
[TD]Yes
[/TD]
[TD]17/04/2018
[/TD]
[/TR]
[TR]
[TD]Newcastle
[/TD]
[TD]Wine
[/TD]
[TD]£2.03
[/TD]
[TD]30
[/TD]
[TD]£60.90
[/TD]
[TD]S
[/TD]
[TD]SS
[/TD]
[TD]No
[/TD]
[TD]18/04/2018
[/TD]
[/TR]
[TR]
[TD]Newcastle
[/TD]
[TD]Beer
[/TD]
[TD]£1.12
[/TD]
[TD]45
[/TD]
[TD]£50.40
[/TD]
[TD]T
[/TD]
[TD]TT
[/TD]
[TD]Yes
[/TD]
[TD]19/04/2018
[/TD]
[/TR]
</tbody>[/TABLE]


So if I enter Leeds, Liverpool or Belfast in Column A, I want that row to be coloured Grey, if I enter Manchester in Column A I want that row to have no colour fill - does that make sense?

Here's hoping someone can help me (and I bet it is mega simple)

Thank you

 

[Fluff]

Try
=OR($A1="London",$A1="Liverpool",$A1="Belfast")

 

[Lesjoan01]

Thank you very much Fluff , that did work but I wanted to whole row to be coloured and it is only colouring the Location - am I trying to do something that Conditional Formatting will not do?

Again than you for your help

Lesley

 

[Fluff]

In the Applies t box put the range of your data, like =$A$1:$I$21
Alternatively select all you data before select the CF

 

[Lesjoan01]

That's it, silly me I actually thought I had selected all the data (obviously not!!!).

Thank you so much, you are a star

Lesley