Using Countif with Conditional Formatting

[SingTuba]

Hello, I am trying to make a sheet that highlights if there are clash between Exam schedules. I can use Countif to check if there are more than one exact slots in a row and highlight the exact cells with Conditional Formatting.
But when I use countif to check overlapping time slots the formula works but Conditional Formatting highlights the entire row. Is it possible for Conditional Formatting to work with my Overlapping Countif formula?.

Book1.xlsx
	A	B	C	D	E	F	G	H	I	J
1
2	Students	Exam and Time				Overlap between two exact Slots	Overlap between Monday Slot 1 and Monday Slot 1.5	Overlap between Tuesday Slot 1 and Tuesday Slot 1.5		Legend
3	Amelia	English	Maths	Art	History					Slot 1 = 10:00 AM -11:30 AM
4	Time Slot	Monday Slot 1	Tuesday Slot 1	Monday Slot 1	Tuesday Slot 2	TRUE	FALSE	FALSE		Slot 1.5 = 10:00 AM - 12:00 PM
5	Jayden	Literature	Maths	Music	Geography					Slot 2 = 11:30 AM-1:00 PM
6	Time Slot	Monday Slot 1	Tuesday Slot 1	Monday Slot 1.5	Tuesday Slot 2	FALSE	TRUE	FALSE		Slot 2.5 = 12:00 PM -1:30 PM
Sheet1

Cell Formulas
Range	Formula
F4	F4	=COUNTIF($B$4:$E$4,B4)>1
G4	G4	=AND(COUNTIF($B$4:$E$4,"Monday Slot 1"),COUNTIF($B$4:$E$4,"Monday Slot 1.5"))
H4	H4	=AND(COUNTIF($B$4:$E$4,"Tuesday Slot 1"),COUNTIF($B$4:$E$4,"Tuesday Slot 1.5"))
F6	F6	=COUNTIF($B$6:$E$6,B6)>1
G6	G6	=AND(COUNTIF($B$6:$E$6,"Monday Slot 1"),COUNTIF($B$6:$E$6,"Monday Slot 1.5"))
H6	H6	=AND(COUNTIF($B$6:$E$6,"Tuesday Slot 1"),COUNTIF($B$6:$E$6,"Tuesday Slot 1.5"))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B6:E6	Expression	=COUNTIF($B$6:$E$6,"Monday Slot 1")+COUNTIF($B$6:$E$6,"Monday Slot 1.5")>1	text	NO
B4:E4	Expression	=COUNTIF($B$4:$E$4,B4)>1	text	NO

 

[Fluff]

How about

=COUNTIF($B$6:$E$6,B6)>1

 

[SingTuba]

How about

=COUNTIF($B$6:$E$6,B6)>1

Hi, yes this formula works for two exact values but I need Conditional Formatting to highlight cells that have text in the Countif formula criteria.

=COUNTIF($B$6:$E$6,"Monday Slot 1")+COUNTIF($B$6:$E$6,"Monday Slot 1.5")>1

 

[Fluff]

How about

=AND(OR(B6="Monday Slot 1",B6="Monday Slot 1.5"),COUNTIF($B$6:$E$6,"Monday Slot 1"),COUNTIF($B$6:$E$6,"Monday Slot 1.5"))

 

[SingTuba]

How about

=AND(OR(B6="Monday Slot 1",B6="Monday Slot 1.5"),COUNTIF($B$6:$E$6,"Monday Slot 1"),COUNTIF($B$6:$E$6,"Monday Slot 1.5"))

Wow this works perfectly, Thank You so much.

 

[Fluff]

You're welcome & thanks for the feedback.