Conditional formatting based on a range in sheet 1

[mbtaichi]

Is there a formula that I can use in conditional formatting to change the background colour of a cell if the same name appears in the range?
On a Sheet called Rota 2 are a list of names in column C.
On a sheet called A/L. I have a range of data A13:H35.
I would like to change the background colour if any of the names in column C (Rota 2) if they appear in column A in the range A13:H35 on the sheet named A/L
Thanks<o></o>

 

[Joe4]

Sure. Used Named Ranges. Name the range on sheet A/L (i.e. "MyRange") then you can use a Conditional Formatting formula like:

=COUNTIF(MyRange,$C1)>0

 

[mbtaichi]

Perfect thank you