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:

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

<tbody>
</tbody>

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