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.

 

[mart37]

What do you mean with: used? Have a value?

 

[loroll1991]

What do you mean with: used? Have a value?

Hello, thanks for the reply!

yes, so

If B10 in TIMETABLE 1 (tab 1) is value Peter and B10 in another tab (TIMETABLE 2 or TIMETABLE 3) is also the value Peter, highlight both cells red.

 

[mart37]

By Conditional Formatting you can refer to an other sheet:
in sheet timetable2 B10: Format cells egaal to -> timetable1!B10
For comparing two cells you need a formula:
in sheet timetable1: new rule -> formula -> =OR(timetable1!B10=timetable2!B10;timetable1!B10=timetable3!B10)

 

[loroll1991]

By Conditional Formatting you can refer to an other sheet:
in sheet timetable2 B10: Format cells egaal to -> timetable1!B10
For comparing two cells you need a formula:
in sheet timetable1: new rule -> formula -> =OR(timetable1!B10=timetable2!B10;timetable1!B10=timetable3!B10)

Thank you so much! Will give this a go now

 

[loroll1991]

By Conditional Formatting you can refer to an other sheet:
in sheet timetable2 B10: Format cells egaal to -> timetable1!B10
For comparing two cells you need a formula:
in sheet timetable1: new rule -> formula -> =OR(timetable1!B10=timetable2!B10;timetable1!B10=timetable3!B10)

I have done this and I am getting the following error

 

[Fluff]

Try changing the semi-colon to a comma

 

[loroll1991]

Try changing the semi-colon to a comma

Thank you, the error has gone but the conditional formatting does not work if the same value is used in B10 in both sheets

 

[mart37]

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

 

[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

Thank you soooooo much!!!!! Worked perfectly.