Formatting Discrepancy

[c772301]

I cannot understand the -red- font color format in cells U4 and U5.
Mini sheet pasted below.
Any help much appreciated!!

RUBY $$$.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1													C-----A-----T-----E-----R-----I-----N-----G
2		Date	In	Out	Tips	Day	Shift	Hrs	Hourly	Total	$/Hr		Date	In	Out	Grat	Hrs	Hourly	Auto	Total	$/Hr
3		19-Feb	11:30 AM	3:45 PM	$143	Saturday	Lunch	4:15	$30	$173	$41		29-Mar	9:15 AM	12:00 PM	$0	2:45	$28	$20	$48	$17
4		19-Feb	3:45 PM	10:05 PM	$122	Saturday	Dinner	6:20	$44	$166	$26		14-Apr	10:00 AM	11:55 AM	$19	1:55	$19	$20	$58	$30
5		20-Feb	11:30 AM	5:45 PM	$119	Sunday	Lunch	6:15	$44	$163	$26		19-Apr	10:15 AM	11:40 AM	$5	1:25	$14	$20	$39	$28
6		22-Feb	3:45 PM	10:00 PM	$93	Tuesday	Dinner	6:15	$44	$137	$22		26-Apr	10:45 AM	12:15 PM	$19	1:30	$15	$20	$54	$36
7										$638	$29
8		24-Feb	5:15 PM	8:15 PM	$50	Thursday	Dinner	3:00	$21	$71	$24
9		25-Feb	3:45 PM	9:45 PM	$110	Friday	Dinner	6:00	$42	$152	$25
10		26-Feb	4:30 PM	8:50 PM	$47	Saturday	Dinner	4:20	$30	$77	$18
11		27-Feb	3:45 PM	10:00 PM	$85	Sunday	Dinner	6:15	$44	$129	$21
12		1-Mar	11:45 AM	5:15 PM	$113	Tuesday	Lunch	5:30	$38	$151	$28
13		1-Mar	5:15 PM	7:00 PM	$22	Tuesday	Dinner	1:45	$12	$34	$20
14										$614	$22
15		3-Mar	4:45 PM	9:00 PM	$50	Thursday	Dinner	4:15	$30	$80	$19
16		6-Mar	11:45 AM	6:30 PM	$113	Sunday	Lunch	6:45	$47	$160	$24
17		6-Mar	6:30 PM	7:00 PM	$7	Sunday	Dinner	0:30	$3	$10	$21
18										$250	$21
19		9-Mar	4:30 PM	6:45 PM	$28	Wednesday	Dinner	2:15	$16	$44	$19
20		11-Mar	11:15 AM	4:00 PM	$72	Friday	Lunch	4:45	$33	$105	$22
21		12-Mar	11:45 AM	2:00 PM	$42	Saturday	Lunch	2:15	$16	$58	$26
22		13-Mar	11:00 AM	3:20 PM	$98	Sunday	Lunch	4:20	$30	$128	$30
23		13-Mar	4:45 PM	7:40 PM	$46	Sunday	Dinner	2:55	$20	$66	$23
24		15-Mar	11:30 AM	5:45 PM	$91	Tuesday	Lunch	6:15	$44	$135	$22
25		15-Mar	6:00 PM	6:45 PM	$4	Tuesday	Dinner	0:45	$5	$9	$12
26										$545	$22
27		17-Mar	4:30 PM	8:15 PM	$56	Thursday	Dinner	3:45	$26	$82	$22
28		18-Mar	3:45 PM	8:45 PM	$75	Friday	Dinner	5:00	$35	$110	$22
29		22-Mar	11:00 AM	5:15 PM	$94	Tuesday	Lunch	6:15	$44	$138	$22
30		22-Mar	5:15 PM	7:45 PM	$30	Tuesday	Dinner	2:30	$17	$47	$19
31										$377	$21
Sheet1

Cell Formulas
Range	Formula
F27:F30,F19:F25,F15:F17,F8:F13,F3:F6	F3	=IF(B3="","",TEXT(B3,"dddd"))
G27:G30,G19:G25,G15:G17,G8:G13,G3:G6	G3	=IF(B3="","",IF(C3<TIME(12,0,0),"Lunch",IF(C3>=TIME(12,0,0),"Dinner","0")))
H27:H30,H19:H25,H15:H17,H8:H13,H3:H6	H3	=IF(B3="","",D3-C3)
I27:I30,I19:I25,I15:I17,I8:I13,I3:I6	I3	=IF(B3="","",6.98*(H3*24))
J27:J30,J19:J25,J15:J17,J8:J13,J3:J6	J3	=IF(B3="","",E3+I3)
K27:K30,K19:K25,K15:K17,K8:K13,K3:K6	K3	=IF(B3="","",J3/(H3*24))
J7,J31	J7	=SUM(J3:J6)
K7,K31	K7	=AVERAGE(K3:K6)
J14	J14	=SUM(J8:J13)
K14	K14	=AVERAGE(K8:K13)
J18	J18	=SUM(J15:J17)
K18	K18	=AVERAGE(K15:K17)
J26	J26	=SUM(J19:J25)
K26	K26	=AVERAGE(K19:K25)
Q27:Q30,Q19:Q25,Q15:Q17,Q8:Q13,Q3:Q6	Q3	=IF(M3="","",O3-N3)
R27:R30,R19:R25,R15:R17,R8:R13,R3:R6	R3	=IF(M3="","",10*(Q3*24))
S27:S30,S19:S25,S15:S17,S8:S13,S3:S6	S3	=IF(M3="","",20)
T27:T30,T19:T25,T15:T17,T8:T13,T3:T6	T3	=IF(M3="","",(P3+R3+S3))
U27:U30,U19:U25,U15:U17,U8:U13,U3:U6	U3	=IF(M3="","",T3/(Q3*24))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
U4:U6	Cell Value	below average	text	NO
U3	Cell Value	below average	text	NO
K3	Cell Value	below average	text	NO
U7:U241	Cell Value	below average	text	NO

 

[saeedkk]

Hello,

the Conditional formating rule for the U4:U6 is below the average,
the average of
30
28
36
Average= 31.33 so the 30 and 28 are below average this is why they have red font.

 

[c772301]

Thank you saeedkk!! I don't know how that conditional formatting got there but it was easy to remove it. Appreciate the help!

 

[saeedkk]

Thank you saeedkk!! I don't know how that conditional formatting got there but it was easy to remove it. Appreciate the help!

Your welcome, Glad to help