Stuck on Conditional Format.

[Geek Girl 007]

I've been at this for hours, I managed to get all the other conditional formatting working but I am stuck on this last one.
Selecting Columns E-M and O on row 5, I want these cells to go to a certain colour when I select a reason from K5, I have managed to do this.
Separately I want the cells to go another colour if there is ANY character in cell L5 - I will never use both formats at the same time i.e. if I have selected from the REASON box I wont select from the ALhrs box and vice versa.......

Please help!!!

TIMESHEET- TEST.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2					Morning		Afternoon		Net Time Worked	Credits					COMMENTS
3					Start Time	Finish Time	Start Time	Finish Time
4					Hrs : Mins	Hrs : Mins	Hrs : Mins	Hrs : Mins	Hrs : Mins	Hrs : Mins	Reason*	AL Hrs	AL Days
5													0
6
7
8
1

Cell Formulas
Range	Formula
I5	I5	=IF((F5-E5)+(H5-G5)=0,"",IF(H5-G5<0,"",(F5-E5)+(H5-G5)))
J5	J5	=IF(OR(K5={"PH","Sick","Covid"}),TIME(7,24,0),"")
M5	M5	=CEILING(L5*24/10,0.5)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E5:M5,O5	Expression	=$K5="RD"	text	NO
E5:M5,O5	Expression	=$K5="Toil"	text	NO
E5:M5,O5	Expression	=$K5="Sick"	text	NO
E5:M5,O5	Expression	=$K5="PH"	text	NO
M5	Cell Value	=0	text	NO

Cells with Data Validation
Cell	Allow	Criteria
K5	List	=DATA!$A$2:$A$9
L5	List	=DATA!$B$2:$B$3

 

[Sergius]

Hello! If correctly understood, then this should help. Create another rule for a conditional format

=$L5<>""

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2					Morning		Afternoon		Net Time Worked	Credits					COMMENTS
3					Start Time	Finish Time	Start Time	Finish Time
4					Hrs : Mins	Hrs : Mins	Hrs : Mins	Hrs : Mins	Hrs : Mins	Hrs : Mins	Reason*	AL Hrs	AL Days
5												4	10
Sheet1

Cell Formulas
Range	Formula
I5	I5	=IF((F5-E5)+(H5-G5)=0,"",IF(H5-G5<0,"",(F5-E5)+(H5-G5)))
J5	J5	=IF(OR(K5={"PH";"Sick";"Covid"}),TIME(7,24,0),"")
M5	M5	=CEILING(L5*24/10,0.5)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E5:M5,O5	Expression	=$L5<>""	text	NO

 

[Geek Girl 007]

Hello! If correctly understood, then this should help. Create another rule for a conditional format

=$L5<>""

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2					Morning		Afternoon		Net Time Worked	Credits					COMMENTS
3					Start Time	Finish Time	Start Time	Finish Time
4					Hrs : Mins	Hrs : Mins	Hrs : Mins	Hrs : Mins	Hrs : Mins	Hrs : Mins	Reason*	AL Hrs	AL Days
5												4	10
Sheet1

Cell Formulas
Range	Formula
I5	I5	=IF((F5-E5)+(H5-G5)=0,"",IF(H5-G5<0,"",(F5-E5)+(H5-G5)))
J5	J5	=IF(OR(K5={"PH";"Sick";"Covid"}),TIME(7,24,0),"")
M5	M5	=CEILING(L5*24/10,0.5)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E5:M5,O5	Expression	=$L5<>""	text	NO

Oh my gosh, Thank you I my ><'s were the wrong way