Highlight if cell is used twice across worksheet

[loroll1991]

I think I may be asking the impossible here but here we go!

I am trying to make conditional formatting across multiple sheets.

Tabs: TIMETABLE 1, TIMETABLE 2, TIMETABLE 3

If B10 in TIMETABLE 1 (tab 1) is used in B10 in another tab (TIMETABLE 2 or TIMETABLE 3) , highlight both cells red.

Is this possible?!

Thanks

Laura.

 

[loroll1991]

Map1
	B
10	5
TIMETABLE1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B10	Expression	=OR(B10=TIMETABLE2!B10,B10=TIMETABLE3!B10)	text	NO

Map1
	B
10	5
TIMETABLE2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B10	Cell Value	=TIMETABLE1!B10	text	NO

One more question which I did not think about, is there a way for it not to highlight the cell red if the value is blank? it is ok for the cells to be blank but we need to see if a value is repeated if that makes sense.

So, IF B10 is blank in TIMETABLE1 and B10 is blank in TIMETABLE2 it will not highlight red?

Thank you

 

[mart37]

Map1
	B
10
TIMETABLE1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B10	Expression	=AND(OR(B10=TIMETABLE2!B10,B10=TIMETABLE3!B10),B10<>"")	text	NO

Map1
	B
10
TIMETABLE2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B10	Expression	=AND(B10=TIMETABLE1!$B$10,B10<>"")	text	NO

 

[loroll1991]

Map1
	B
10
TIMETABLE1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B10	Expression	=AND(OR(B10=TIMETABLE2!B10,B10=TIMETABLE3!B10),B10<>"")	text	NO

Map1
	B
10
TIMETABLE2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B10	Expression	=AND(B10=TIMETABLE1!$B$10,B10<>"")	text	NO

Honestly, thank you so much.