conditional formatting with multiple criteria

[jbrown021286]

hours log.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	4/26/2024
2		Day	date	notes	Column2	RO	status	SUM	Daignosis	CODE	JOB	FLAG TIME	ADJUSTMENT	Column1
3		Saturday	4/20/2024			6209943	g	1.0		k	key	1
4		Saturday	4/20/2024		x	6209847		1.0		d	Diag	1
5		Monday	4/22/2024			6208395	g	1.0					1
6		Monday	4/22/2024			6209839	g	1.0					1
7		Monday	4/22/2024			6209944	g	0.5					0.5
8		Monday	4/22/2024			6209944	g	0.5					0.5
9		Monday	4/22/2024			6209944	g	1.5					1.5
10		Monday	4/22/2024			6209996	g	0.7					0.7
11		Monday	4/22/2024			6209996	g	1.4					1.4
12		Monday	4/22/2024			6210011	g	2.0		9ts	9speed	2
13		Tuesday	4/23/2024			6209999	g	1.4		pdi	pdi	1.4
14		Tuesday	4/23/2024			6209999	g	0.7		pro	propack	0.7
15		Tuesday	4/23/2024			6209405	g	0.2	window molding				0.2
16		Tuesday	4/23/2024			6210012	g	10.0	oil pump				10
17		Tuesday	4/23/2024			6210012	g	2.0	ps pump				2
18		Tuesday	4/23/2024			6210012	g	1.0	head light rest				1
19		Wednesday	4/24/2024		x	6210041		10.0					10
20		Friday	4/26/2024		x	6210041		0.1		af	air filter	0.1
21		Wednesday	4/24/2024		x	6210041		0.2		cf	cabin filter	0.2
22		Wednesday	4/24/2024		x	6210041		0.3					0.3
23		Wednesday	4/24/2024			6210178		1.4		pdi	pdi	1.4
24		Wednesday	4/24/2024			6210185		2.0	adas				2
25		Wednesday	4/24/2024			6209974		0.2		cf	cabin filter	0.2
26		Wednesday	4/24/2024			6209974		0.1		af	air filter	0.1
27		Wednesday	4/24/2024			6209974		0.8		bs	Brake Service	0.8
28		Wednesday	4/24/2024			6209974		0.5		ts	Trans service	0.5
29		Wednesday	4/24/2024			6209974		1.5		br	turn rotors	1.5
30		Wednesday	4/24/2024			6209974		3.0					3
31		Wednesday	4/24/2024			6209974		1.0		cs	Coolant Service	1
32		Wednesday	4/24/2024			6210094		3.0					3
33		Wednesday	4/24/2024			6210094		1.5					1.5
34		Wednesday	4/24/2024			6210192		1.0					1
35
36
37
Log

Cell Formulas
Range	Formula
A1	A1	=TODAY()
K3:K37	K3	=IF(J3="","",INDEX($AA$3:$AA$91,MATCH(J3,$Z$3:$Z$91,0),1))
L3:L37	L3	=IF(K3="","",INDEX($AB$3:$AB$91,MATCH(J3,$Z$3:$Z$91,0),1))
C3:C4,C12:C37	C3	=IF([@RO]<>"",IF(C3="",TODAY(),C3),"")
B3:B37	B3	=IFERROR(TEXT(WEEKDAY($C3),"Dddd"),"")
H3:H37	H3	=SUMIF(Table1112933[@[FLAG TIME]:[ADJUSTMENT]],"<>",Table1112933[@[FLAG TIME]:[ADJUSTMENT]])

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F3:F280,M22:M52	Expression	=COUNTIF(W:W,F3)>0	text	NO
G3:G280	Cell Value	=$P$33	text	NO
I5:I7	Cell Value	=$P$32	text	NO
I5:I7	Cell Value	=$P$31	text	NO
I5:I7	Cell Value	=$P$30	text	NO
I5:I7	Cell Value	=$P$29	text	NO
I5:I7	Cell Value	=$P$28	text	NO
I5:I7	Cell Value	=$P$27	text	NO
I19	Cell Value	=$P$32	text	NO
I19	Cell Value	=$P$31	text	NO
I19	Cell Value	=$P$30	text	NO
I19	Cell Value	=$P$29	text	NO
I19	Cell Value	=$P$28	text	NO
I19	Cell Value	=$P$27	text	NO
G3:G280	Cell Value	=$P$32	text	NO
G3:H280	Cell Value	=$P$31	text	NO
G3:H280	Cell Value	=$P$30	text	NO
G3:H280	Cell Value	=$P$29	text	NO
G3:H280	Cell Value	=$P$28	text	NO
G3:H280	Cell Value	=$P$27	text	NO
H3:H280	Expression	=" =COUNTIFS(D:D,A1,E:E,J2)>0"	text	NO
H3:H280	Expression	=COUNTIFS(W:W,F3,X:X,H3)>0	text	NO
M3:O5,N6:O7	Expression	=COUNTIFS(XFA:XFA,L3,XFC:XFC,M3)>0	text	NO
F28:F38	Expression	=COUNTIF(XEU:XEU,F28)>0	text	NO

i need to make 2 conditional formatting formulas for column E. the first formula needs to highlight the cell if the adjacent cell in column f has a value in it and the cell column E is "x". the second formula needs to highlight the cell in column E if the adjacent cell in F has a value and the cell in E is empty. any help would be appreciated.

 

[Cubist]

Formula 1:

=(E3="x")*(F3<>"")

Formula 2:

=(E3="")*(F3<>"")

 

[jbrown021286]

That got it than
ks

 

[jbrown021286]

Formula 1:

=(E3="x")*(F3<>"")

Formula 2:

=(E3="")*(F3<>"")

That got it than
ks

i was trying to add another argument that returns a true value if E has an X in it and c = A1. I'm not sure what is wrong with this formula =(E3="x")*(C3=A$1$"") but it does not work

 

[jbrown021286]

Formula 1:

=(E3="x")*(F3<>"")

Formula 2:

=(E3="")*(F3<>"")

i was trying to add another argument that returns a true value if E has an X in it and c = A1. I'm not sure what is wrong with this formula =(E3="x")*(C3=A$1$"") but it does not work

 

[Cubist]

Try

=(E3="x")*(C3=$A$1)

 

[jbrown021286]

Please explain what you're trying to do in words.

column c is a date time stamp that is logged when column f cells are filled and A1 is the current date. i am wanting to conditionally format E if it has an "x" in it and the time stamp date in column c is = to the date in A1

 

[Cubist]

column c is a date time stamp that is logged when column f cells are filled and A1 is the current date. i am wanting to conditionally format E if it has an "x" in it and the time stamp date in column c is = to the date in A1

I've edited my post above. See if the formula works for you.

 

[jbrown021286]

Try

=(E3="x")*(C3=$A$1)

that got it thx