conditional formatting with multiple conditions

[Kyttdina]

column a= room number, column B person name, column C,D, E= cells which should be highlighted after the data (K) is manually inserted
if anyone in the same room is K the others should be highlighted
If anyone from the same room is C or empty then no highlight is needed
If anyone in the room is K, then C will be entered into highlighted cell
(the highlight is necessary for not having two K at the same time in same room)

i hope i explained it well enough (English is my third language, i apologize for mistakes)
thank you in advance

 

[Eric W]

Try:

Book2
	A	B	C	D	E
1	room	name	13:00	14:00	15:00
2	101	aaa	k	2
3	101	bbb	1	2
4	101	ccc
5	101	ddd	c	2
6	111	ccc	k	k	2
7	111	ddd
8	111	aaa
9	121	bbb
10	121	ccc		k	2
11	121	ddd
12	121	aaa
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C2:E12	Expression	=COUNTIFS($A$2:$A$12,$A2,B$2:B$12,"K",C$2:C$12,2)	text	NO
C2:E12	Expression	=COUNTIFS($A$2:$A$12,$A2,C$2:C$12,"K")	text	NO

 

[Kyttdina]

Try:

Book2
	A	B	C	D	E
1	room	name	13:00	14:00	15:00
2	101	aaa	k	2
3	101	bbb	1	2
4	101	ccc
5	101	ddd	c	2
6	111	ccc	k	k	2
7	111	ddd
8	111	aaa
9	121	bbb
10	121	ccc		k	2
11	121	ddd
12	121	aaa
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C2:E12	Expression	=COUNTIFS($A$2:$A$12,$A2,B$2:B$12,"K",C$2:C$12,2)	text	NO
C2:E12	Expression	=COUNTIFS($A$2:$A$12,$A2,C$2:C$12,"K")	text	NO

i am speechless. thank you so much. works perfectly!
you are my hero!
Dina

 

[Eric W]

Glad it works for you! ?