Conditional formatting If cell value exist within a range on another sheet

[Koboca]

I am creating a class scheduler

the first sheet is a table containing the information as to where the class should be placed. the second sheet is a schedule that contains that class.

I want to make it easy for the user to tell if a class is already on the schedule by conditionally formatting the row in the table on the first sheet if the data exist within the schedule range on the second sheet. But I Cannot figure out what that formula would look it.

sheet 1

sheet 2

I currently have this in an attempt to just formating the cell containing the class name and not the whole row but even this does not work

=NOT(ISNA(VLOOKUP($A$2:$A$38,Sheet2!$B$2:$J$17,1,FALSE)))

the range on sheet 1 is called ClassList and on Sheet 2 it is ClassSchedule. The class name exists In column A of ClassList

Thanks for your help in Advance

Thanks

 

[Fluff]

Hi & welcome to MrExcel.
How about

=AGGREGATE(15,6,ROW(Sheet2!$B$2:$B$17)/(Sheet2!$B$2:$J$17=A2),1)

 

[Joe4]

Welcome to the Board!

Is this what you are looking for?

=COUNTIF(Sheet2!$B$2:$J$17,A2)>0

 

[Koboca]

Welcome to the Board!

Is this what you are looking for?

=COUNTIF(Sheet2!$B$2:$J$17,A2)>0

Thank you, This is almost exactly what I am looking for!

however, this only applies the formatting to column A how can I apply it to the whole row

 

[Joe4]

When creating the Conditional Formatting rule, select the whole row (not just column A).
And then we just need to lock the column A reference in our CF formula like this:

=COUNTIF(Sheet2!$B$2:$J$17,$A2)>0

and then it will apply to the whole row.