conditional formatting based on duplicate cells

J

jbrown021286

Board Regular
Joined
Mar 13, 2023
Messages
74
Office Version
  1. 365
Platform
  1. Windows
hours log.xlsx
ABCDEFGHIJKLMOPQRSTUVWXY
17/5/2024
2DaydatenotesColumn2ROstatusSUMDaignosisCODEJOBFLAG TIMEADJUSTMENTR.O.Hours
3Friday7/5/2024 6215160g5.0aii  5don’t countWaitingincorect 62148632
4Wednesday7/3/2024 6215160g5.0aii  5000AdjustmentCheck List62149490.3
5Thursday7/4/2024 6215271g3.0  3Todays totalBalance non verifyedBalance verifyed68.662149490.3
6Tuesday7/2/2024michaelX62130190.7propropack0.717-6.3-37.062149491
7Tuesday7/2/2024michaelX62130191.4pdipdi1.4TotalNot VerifyedVerifyed62149490.3
8Tuesday7/2/2024michaelX62130193.0  353.730.72362149502.3
9Tuesday7/2/2024michaelX62148632.0camera aim  262150312
10Tuesday7/2/2024terrance 6215187g6.0  662150350.5
11Wednesday7/3/2024 6215232g4.0bcm  4Diags Waiting62150350.5
12Thursday7/4/2024X62152771.0dDiag1WriterDiag Rosum62150361
13Thursday7/4/2024X62152811.5  1.562150402
14Monday7/1/2024evanX1hgcm564x5a0558881.0compressordDiag162150410.5
15Tuesday7/2/2024michaelX2hgfe2f21rh5951751.4pdipdi1.462151605
16Tuesday7/2/2024michaelX2hgfe2f21rh5951760.7propropack0.762151605
17Tuesday7/2/2024evanX2hkrm3h50gh5119142.0axle seal  2DayHoursAverage62151851.4
18Monday7/1/2024richardXJH4CL96897C0157101.0harness repair  1xMonday5.010.762151850.7
19Monday7/1/2024lindseyXjhlre38318c0092291.0batterydDiag1xTuesday17.262151876
20Monday7/1/2024lindseyXjhlre38318c0092291.0discharge hosedDiag1xWednesday9.0621521315
21Monday7/1/2024lindseyXjhlre38318c0092291.0motordDiag1xThursday5.562152133
22Friday7/5/2024X62152353.0  3xFriday0.062152324
23Friday7/5/2024X62152355.0  5xSaturday0.062152353
24Friday7/5/2024X62152354.0  462152354
25      xToday 1762152354
26      62152713
27      62152710.3
28      62152811.5
29      
Log
Cell Formulas
RangeFormula
A1A1=TODAY()
K3:K29K3=IF(J3="","",INDEX($AB$3:$AB$91,MATCH(J3,$AA$3:$AA$91,0),1))
L3:L29L3=IF(K3="","",INDEX($AC$3:$AC$91,MATCH(J3,$AA$3:$AA$91,0),1))
P4P4=SUMIF(G:G,"N",H:H)+SUMIF(G:G,"cnf",H:H)
Q4Q4=SUMIF(G:G,"w",H:H)
R4R4=SUMIF(G:G,"x",H:H)
U5U5=SUM(Y:Y)-T5
P6P6=SUMIF($C$3:$C$280,A1,$H3:$H280)-SUMIFS(Table1112933[SUM],Table1112933[date],A1,Table1112933[status],"=n")-SUMIFS(Table1112933[SUM],Table1112933[date],A1,Table1112933[status],"=gn")
Q6Q6=P8-AW4
R6R6=R8-AW4
P8P8=SUM(H:H,)-SUMIF(G:G,"N",H:H)-SUMIF(G:G,"nf",H:H)-SUMIF(Table1112933[status],"=GN",Table1112933[SUM])
Q8Q8=SUMIF(G:G,"",H:H)+SUMIF(G:G,"c",H:H)
R8R8=SUMIF(G:G,"G",H:H)-Q11
C3:C9,C15:C29,C11:C13C3=IF([@RO]<>"",IF(C3="",TODAY(),C3),"")
B3:B29B3=IFERROR(TEXT(WEEKDAY($C3),"Dddd"),"")
R18R18=IFERROR(AVERAGEIFS(Q18:Q25,Q18:Q25,">0",O18:O25,"X"),0)
Q18:Q23Q18=SUMIFS($H$3:$H$280,$B$3:$B$280,P18,$C$3:$C$280,"<"&A$1)-SUMIFS(Table1112933[SUM],Table1112933[status],"GN",Table1112933[Day],P18)-SUMIFS(Table1112933[SUM],Table1112933[status],"N",Table1112933[Day],P18)-SUMIFS(Table1112933[SUM],Table1112933[status],"W",Table1112933[Day],P18)
Q25Q25=SUMIF($C$3:$C$280,A1,$H3:$H280)-SUMIFS(Table1112933[SUM],Table1112933[date],A1,Table1112933[status],"=n")-SUMIFS(Table1112933[SUM],Table1112933[date],A1,Table1112933[status],"=gn")-SUMIFS(Table1112933[SUM],Table1112933[date],A1,Table1112933[status],"=W")
E3:E26E3=IF(OR(AND(F3="",G3=""),AND(F3<>"",G3="G")),"",IF(AND(F3<>"",G3="GN"),"",IF(AND(F3<>"",G3=""),"X","***")))
E27:E29E27=IF(OR(AND(D27="",G27=""),AND(D27<>"",G27="G")),"",IF(AND(D27<>"",G27="GN"),"",IF(AND(D27<>"",G27=""),"X","***")))
H3:H29H3=SUMIF(Table1112933[@[FLAG TIME]:[ADJUSTMENT]],"<>",Table1112933[@[FLAG TIME]:[ADJUSTMENT]])
Cells with Conditional Formatting
CellConditionCell FormatStop If True
X3:Y281Expression=COUNTIF(F:F,X3)>0textNO
X3:Y281Expression=COUNTIFS(F:F,X3,H:H,Y3)>0textNO
U13:U35Expression=COUNTIFS(X:X,U13,Y:Y,V13)>0textNO
V13Expression=COUNTIFS(Y:Y,U13,Z:Z,V13)>0textNO
G3:G280Cell Value=$P$38textNO
Q6:R6Cell Value>-0.1textNO
Q6:R6Cell Value>-0.1textNO
Q6:R6Cell Value<0textNO
M22:M52,F30:F32,F34:F88,F91:F280,F3:F26Expression=COUNTIF(X:X,F3)>0textNO
E3:E280Expression=(E3="x")*(C3=$A$1)textNO
E3:E26,E30:E280Expression=(E3="")*(F3<>"")textNO
E3:E26,E30:E280Expression=(E3="x")*(F3<>"")textNO
G3:G88,G91:G280,I5:I8Cell Value=$P$43textNO
G3:G88,I5:I8,G91:G280Cell Value=$P$42textNO
G3:H4,G4:G14,H5:I8,G10:H88,G91:H280,H9Cell Value=$P$41textNO
H3:H88,H91:H280Expression=" =COUNTIFS(D:D,A1,E:E,J2)>0"textNO
H3:H88,H91:H280Expression=COUNTIFS(X:X,F3,Y:Y,H3)>0textNO
G3:H4,H5:I8,H9,G10:H88,G91:H280,G4:G14Cell Value=$P$40textNO
G3:H4,G4:G14,H5:I8,H9,G10:H88,G91:H280Cell Value=$P$39textNO
G3:H4,G4:G14,H5:I8,H9,G10:H88,G91:H280Cell Value=$P$37textNO
G3:H4,G4:G14,H5:I8,H9,G10:H88,G91:H280Cell Value=$P$36textNO
I19Cell Value=$P$42textNO
I19Cell Value=$P$41textNO
I19Cell Value=$P$40textNO
I19Cell Value=$P$39textNO
I19Cell Value=$P$37textNO
I19Cell Value=$P$36textNO
M3:O5Expression=COUNTIFS(XFB:XFB,L3,XFD:XFD,M3)>0textNO
N6:O7Expression=COUNTIFS(XFC:XFC,M6,#REF!,N6)>0textNO
E27:E29Expression=(E27="")*(D27<>"")textNO
E27:E29Expression=(E27="x")*(D27<>"")textNO
D29,D33Expression=COUNTIF(X:X,D29)>0textNO
D29,D33Expression=COUNTIF(XEV:XEV,D29)>0textNO

i am not sure why my conditioning formulas in columns X and Y. i need the cells in x and y to be highlighted if they have matching cells in f and h. this is a similar function that i have f and h conditionally formatted with. any help would be appreciated
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Sort by date Sort by votes
Because you are applying the formula to a multi-column range (X and Y), you need to lock the column references in your CF formula, i.e.
Excel Formula: 
=COUNTIFS(F:F,X3,H:H,Y3)>0
should be:
Excel Formula: 
=COUNTIFS($F:$F,$X3,$H:$H,$Y3)>0

But note that compare the values in X3 and Y3 to ANY rows in columns F and H.
If you only want it to look at the same row, you should use this instead:
Excel Formula: 
=AND($F3=$X3,$H3=$Y3)
 
Upvote 0
Solution
hours log.xlsx
ABCDEFGHIJKLMOPQRSTUVWXY
17/8/2024
2DaydatenotesColumn2ROstatusSUMDaignosisCODEJOBFLAG TIMEADJUSTMENTR.O.Hours
3Tuesday7/2/2024michael 6214863g2.0camera aim  2don’t countWaitingincorect 62148632
4Monday7/1/2024evan 6215036g1.0compressordDiag1000AdjustmentCheck List62149490.3
5Friday7/5/2024 6215160g5.0aii  5Todays totalBalance non verifyedBalance verifyed71.362149490.3
6Wednesday7/3/2024 6215160g5.0aii  5060.936.662149490
7Tuesday7/2/2024michael 6215185g0.7propropack0.7TotalNot VerifyedVerifyed62149490
8Tuesday7/2/2024michael 6215185g1.4pdipdi1.475.919.351.662149491
9Tuesday7/2/2024terrance 6215187g6.0  662149490.3
10Saturday7/6/2024 6215213g15.0  1562149490
11Wednesday7/3/2024 6215232g4.0bcm  4Diags Waiting62149502.3
12Friday7/5/2024 6215235g3.0  3WriterDiag Rosum62149500
13Friday7/5/2024 6215235g4.0  462150312
14Thursday7/4/2024 6215271g3.0  362150350.5
15Thursday7/4/2024 6215281g1.5  1.562150350.5
16Tuesday7/2/2024michaelX62130190.7propropack0.762150360
17Tuesday7/2/2024michaelX62130191.4pdipdi1.4DayHoursAverage62150360
18Tuesday7/2/2024michaelX62130193.0  3xMonday5.012.762150361
19Saturday7/6/2024 62138493.0  3xTuesday17.262150402
20Monday7/1/2024richardX62139311.0harness repair  1xWednesday9.062150410.5
21Friday7/5/2024X62152355.0  5xThursday5.562151061
22Thursday7/4/2024X62152771.0dDiag1xFriday19.562151605
23Friday7/5/2024X62153682.5spinning stud  2.5xSaturday19.762151605
24Saturday7/6/2024 62154280.7  0.762151851.4
25Saturday7/6/2024 62154811.0dDiag1xToday 062151850.7
26Tuesday7/2/2024evan***2hkrm3h50gh511914No line2.0axle seal  262151876
27Monday7/1/2024lindsey***jhlre38318c009229no r.o. made 1.0batterydDiag1621521315
28Monday7/1/2024lindsey***jhlre38318c009229no r.o. made 1.0discharge hosedDiag162152133
29Monday7/1/2024lindsey***jhlre38318c009229no r.o. made 1.0motordDiag162152310
30      62152310
31      62152324
32      62152353
33      62152354
34      62152354
35      62152350
Log
Cell Formulas
RangeFormula
A1A1=TODAY()
C3,C10:C35,C5:C8C3=IF([@RO]<>"",IF(C3="",TODAY(),C3),"")
K3:K35K3=IF(J3="","",INDEX($AB$3:$AB$91,MATCH(J3,$AA$3:$AA$91,0),1))
L3:L35L3=IF(K3="","",INDEX($AC$3:$AC$91,MATCH(J3,$AA$3:$AA$91,0),1))
P4P4=SUMIF(G:G,"N",H:H)+SUMIF(G:G,"cnf",H:H)
Q4Q4=SUMIF(G:G,"w",H:H)
R4R4=SUMIF(G:G,"x",H:H)
U5U5=SUM(Y:Y)-T5
P6P6=SUMIF($C$3:$C$280,A1,$H3:$H280)-SUMIFS(Table1112933[SUM],Table1112933[date],A1,Table1112933[status],"=n")-SUMIFS(Table1112933[SUM],Table1112933[date],A1,Table1112933[status],"=gn")
Q6Q6=P8-AW4
R6R6=R8-AW4
P8P8=SUM(H:H,)-SUMIF(G:G,"N",H:H)-SUMIF(G:G,"nf",H:H)-SUMIF(Table1112933[status],"=GN",Table1112933[SUM])
Q8Q8=SUMIF(G:G,"",H:H)+SUMIF(G:G,"c",H:H)
R8R8=SUMIF(G:G,"G",H:H)-Q11
B3:B35B3=IFERROR(TEXT(WEEKDAY($C3),"Dddd"),"")
R18R18=IFERROR(AVERAGEIFS(Q18:Q25,Q18:Q25,">0",O18:O25,"X"),0)
Q18:Q23Q18=SUMIFS($H$3:$H$280,$B$3:$B$280,P18,$C$3:$C$280,"<"&A$1)-SUMIFS(Table1112933[SUM],Table1112933[status],"GN",Table1112933[Day],P18)-SUMIFS(Table1112933[SUM],Table1112933[status],"N",Table1112933[Day],P18)-SUMIFS(Table1112933[SUM],Table1112933[status],"W",Table1112933[Day],P18)
Q25Q25=SUMIF($C$3:$C$280,A1,$H3:$H280)-SUMIFS(Table1112933[SUM],Table1112933[date],A1,Table1112933[status],"=n")-SUMIFS(Table1112933[SUM],Table1112933[date],A1,Table1112933[status],"=gn")-SUMIFS(Table1112933[SUM],Table1112933[date],A1,Table1112933[status],"=W")
E3:E18,E20:E23,E26:E35E3=IF(OR(AND(F3="",G3=""),AND(F3<>"",G3="G")),"",IF(AND(F3<>"",G3="GN"),"",IF(AND(F3<>"",G3=""),"X","***")))
E19,E24:E25E19=IF(OR(AND(D19="",G19=""),AND(D19<>"",G19="G")),"",IF(AND(D19<>"",G19="GN"),"",IF(AND(D19<>"",G19=""),"X","***")))
H3:H35H3=SUMIF(Table1112933[@[FLAG TIME]:[ADJUSTMENT]],"<>",Table1112933[@[FLAG TIME]:[ADJUSTMENT]])
Cells with Conditional Formatting
CellConditionCell FormatStop If True
F18Expression=COUNTIF(X:X,F18)>0textNO
F18Expression=COUNTIF(XEV:XEV,F18)>0textNO
F16Expression=COUNTIF(X:X,F16)>0textNO
F16Expression=COUNTIF(XEV:XEV,F16)>0textNO
F15Expression=COUNTIF(X:X,F15)>0textNO
F15Expression=COUNTIF(XEV:XEV,F15)>0textNO
F14Expression=COUNTIF(X:X,F14)>0textNO
F14Expression=COUNTIF(XEV:XEV,F14)>0textNO
X3:Y281Expression=COUNTIF(F:F,X3)>0textNO
X3:Y281Expression="($F:$F,$X3,$H:$H,$Y3)>0"textNO
U13:U35Expression=COUNTIFS(X:X,U13,Y:Y,V13)>0textNO
V13Expression=COUNTIFS(Y:Y,U13,Z:Z,V13)>0textNO
G3:G280Cell Value=$P$38textNO
Q6:R6Cell Value>-0.1textNO
Q6:R6Cell Value>-0.1textNO
Q6:R6Cell Value<0textNO
M22:M52,F30:F32,F34:F88,F91:F280,F3:F13,F17,F19:F26Expression=COUNTIF(X:X,F3)>0textNO
E3:E280Expression=(E3="x")*(C3=$A$1)textNO
E3:E26,E30:E280Expression=(E3="")*(F3<>"")textNO
E3:E26,E30:E280Expression=(E3="x")*(F3<>"")textNO
G91:G280,I5:I8,G3:G88Cell Value=$P$43textNO
I5:I8,G91:G280,G3:G88Cell Value=$P$42textNO
G3:H4,G4:G14,H5:I8,G91:H280,H9,G10:H88Cell Value=$P$41textNO
H3:H88,H91:H280Expression=" =COUNTIFS(D:D,A1,E:E,J2)>0"textNO
H3:H88,H91:H280Expression=COUNTIFS(X:X,F3,Y:Y,H3)>0textNO
F30:F32,F34:F42Expression=COUNTIF(XEV:XEV,F30)>0textNO
G3:H4,H5:I8,H9,G91:H280,G4:G16,G10:H88Cell Value=$P$40textNO
G3:H4,G4:G14,H5:I8,H9,G91:H280,G10:H88Cell Value=$P$39textNO
G3:H4,G4:G14,H5:I8,H9,G91:H280,G10:H88Cell Value=$P$37textNO
G3:H4,G4:G14,H5:I8,H9,G91:H280,G10:H88Cell Value=$P$36textNO
I19Cell Value=$P$42textNO
I19Cell Value=$P$41textNO
I19Cell Value=$P$40textNO
I19Cell Value=$P$39textNO
I19Cell Value=$P$37textNO
I19Cell Value=$P$36textNO
M3:O5Expression=COUNTIFS(XFB:XFB,L3,XFD:XFD,M3)>0textNO
N6:O7Expression=COUNTIFS(XFC:XFC,M6,#REF!,N6)>0textNO
E27:E29Expression=(E27="")*(D27<>"")textNO
E27:E29Expression=(E27="x")*(D27<>"")textNO
D29,D33Expression=COUNTIF(X:X,D29)>0textNO
D29,D33Expression=COUNTIF(XEV:XEV,D29)>0textNO
it is still not working. did i do somthing wrong when i entered the formula?
 
Upvote 0
jbrown021286 said:
hours log.xlsx
ABCDEFGHIJKLMOPQRSTUVWXY
17/8/2024
2DaydatenotesColumn2ROstatusSUMDaignosisCODEJOBFLAG TIMEADJUSTMENTR.O.Hours
3Tuesday7/2/2024michael 6214863g2.0camera aim  2don’t countWaitingincorect 62148632
4Monday7/1/2024evan 6215036g1.0compressordDiag1000AdjustmentCheck List62149490.3
5Friday7/5/2024 6215160g5.0aii  5Todays totalBalance non verifyedBalance verifyed71.362149490.3
6Wednesday7/3/2024 6215160g5.0aii  5060.936.662149490
7Tuesday7/2/2024michael 6215185g0.7propropack0.7TotalNot VerifyedVerifyed62149490
8Tuesday7/2/2024michael 6215185g1.4pdipdi1.475.919.351.662149491
9Tuesday7/2/2024terrance 6215187g6.0  662149490.3
10Saturday7/6/2024 6215213g15.0  1562149490
11Wednesday7/3/2024 6215232g4.0bcm  4Diags Waiting62149502.3
12Friday7/5/2024 6215235g3.0  3WriterDiag Rosum62149500
13Friday7/5/2024 6215235g4.0  462150312
14Thursday7/4/2024 6215271g3.0  362150350.5
15Thursday7/4/2024 6215281g1.5  1.562150350.5
16Tuesday7/2/2024michaelX62130190.7propropack0.762150360
17Tuesday7/2/2024michaelX62130191.4pdipdi1.4DayHoursAverage62150360
18Tuesday7/2/2024michaelX62130193.0  3xMonday5.012.762150361
19Saturday7/6/2024 62138493.0  3xTuesday17.262150402
20Monday7/1/2024richardX62139311.0harness repair  1xWednesday9.062150410.5
21Friday7/5/2024X62152355.0  5xThursday5.562151061
22Thursday7/4/2024X62152771.0dDiag1xFriday19.562151605
23Friday7/5/2024X62153682.5spinning stud  2.5xSaturday19.762151605
24Saturday7/6/2024 62154280.7  0.762151851.4
25Saturday7/6/2024 62154811.0dDiag1xToday 062151850.7
26Tuesday7/2/2024evan***2hkrm3h50gh511914No line2.0axle seal  262151876
27Monday7/1/2024lindsey***jhlre38318c009229no r.o. made 1.0batterydDiag1621521315
28Monday7/1/2024lindsey***jhlre38318c009229no r.o. made 1.0discharge hosedDiag162152133
29Monday7/1/2024lindsey***jhlre38318c009229no r.o. made 1.0motordDiag162152310
30      62152310
31      62152324
32      62152353
33      62152354
34      62152354
35      62152350
Log
Cell Formulas
RangeFormula
A1A1=TODAY()
C3,C10:C35,C5:C8C3=IF([@RO]<>"",IF(C3="",TODAY(),C3),"")
K3:K35K3=IF(J3="","",INDEX($AB$3:$AB$91,MATCH(J3,$AA$3:$AA$91,0),1))
L3:L35L3=IF(K3="","",INDEX($AC$3:$AC$91,MATCH(J3,$AA$3:$AA$91,0),1))
P4P4=SUMIF(G:G,"N",H:H)+SUMIF(G:G,"cnf",H:H)
Q4Q4=SUMIF(G:G,"w",H:H)
R4R4=SUMIF(G:G,"x",H:H)
U5U5=SUM(Y:Y)-T5
P6P6=SUMIF($C$3:$C$280,A1,$H3:$H280)-SUMIFS(Table1112933[SUM],Table1112933[date],A1,Table1112933[status],"=n")-SUMIFS(Table1112933[SUM],Table1112933[date],A1,Table1112933[status],"=gn")
Q6Q6=P8-AW4
R6R6=R8-AW4
P8P8=SUM(H:H,)-SUMIF(G:G,"N",H:H)-SUMIF(G:G,"nf",H:H)-SUMIF(Table1112933[status],"=GN",Table1112933[SUM])
Q8Q8=SUMIF(G:G,"",H:H)+SUMIF(G:G,"c",H:H)
R8R8=SUMIF(G:G,"G",H:H)-Q11
B3:B35B3=IFERROR(TEXT(WEEKDAY($C3),"Dddd"),"")
R18R18=IFERROR(AVERAGEIFS(Q18:Q25,Q18:Q25,">0",O18:O25,"X"),0)
Q18:Q23Q18=SUMIFS($H$3:$H$280,$B$3:$B$280,P18,$C$3:$C$280,"<"&A$1)-SUMIFS(Table1112933[SUM],Table1112933[status],"GN",Table1112933[Day],P18)-SUMIFS(Table1112933[SUM],Table1112933[status],"N",Table1112933[Day],P18)-SUMIFS(Table1112933[SUM],Table1112933[status],"W",Table1112933[Day],P18)
Q25Q25=SUMIF($C$3:$C$280,A1,$H3:$H280)-SUMIFS(Table1112933[SUM],Table1112933[date],A1,Table1112933[status],"=n")-SUMIFS(Table1112933[SUM],Table1112933[date],A1,Table1112933[status],"=gn")-SUMIFS(Table1112933[SUM],Table1112933[date],A1,Table1112933[status],"=W")
E3:E18,E20:E23,E26:E35E3=IF(OR(AND(F3="",G3=""),AND(F3<>"",G3="G")),"",IF(AND(F3<>"",G3="GN"),"",IF(AND(F3<>"",G3=""),"X","***")))
E19,E24:E25E19=IF(OR(AND(D19="",G19=""),AND(D19<>"",G19="G")),"",IF(AND(D19<>"",G19="GN"),"",IF(AND(D19<>"",G19=""),"X","***")))
H3:H35H3=SUMIF(Table1112933[@[FLAG TIME]:[ADJUSTMENT]],"<>",Table1112933[@[FLAG TIME]:[ADJUSTMENT]])
Cells with Conditional Formatting
CellConditionCell FormatStop If True
F18Expression=COUNTIF(X:X,F18)>0textNO
F18Expression=COUNTIF(XEV:XEV,F18)>0textNO
F16Expression=COUNTIF(X:X,F16)>0textNO
F16Expression=COUNTIF(XEV:XEV,F16)>0textNO
F15Expression=COUNTIF(X:X,F15)>0textNO
F15Expression=COUNTIF(XEV:XEV,F15)>0textNO
F14Expression=COUNTIF(X:X,F14)>0textNO
F14Expression=COUNTIF(XEV:XEV,F14)>0textNO
X3:Y281Expression=COUNTIF(F:F,X3)>0textNO
X3:Y281Expression="($F:$F,$X3,$H:$H,$Y3)>0"textNO
U13:U35Expression=COUNTIFS(X:X,U13,Y:Y,V13)>0textNO
V13Expression=COUNTIFS(Y:Y,U13,Z:Z,V13)>0textNO
G3:G280Cell Value=$P$38textNO
Q6:R6Cell Value>-0.1textNO
Q6:R6Cell Value>-0.1textNO
Q6:R6Cell Value<0textNO
M22:M52,F30:F32,F34:F88,F91:F280,F3:F13,F17,F19:F26Expression=COUNTIF(X:X,F3)>0textNO
E3:E280Expression=(E3="x")*(C3=$A$1)textNO
E3:E26,E30:E280Expression=(E3="")*(F3<>"")textNO
E3:E26,E30:E280Expression=(E3="x")*(F3<>"")textNO
G91:G280,I5:I8,G3:G88Cell Value=$P$43textNO
I5:I8,G91:G280,G3:G88Cell Value=$P$42textNO
G3:H4,G4:G14,H5:I8,G91:H280,H9,G10:H88Cell Value=$P$41textNO
H3:H88,H91:H280Expression=" =COUNTIFS(D:D,A1,E:E,J2)>0"textNO
H3:H88,H91:H280Expression=COUNTIFS(X:X,F3,Y:Y,H3)>0textNO
F30:F32,F34:F42Expression=COUNTIF(XEV:XEV,F30)>0textNO
G3:H4,H5:I8,H9,G91:H280,G4:G16,G10:H88Cell Value=$P$40textNO
G3:H4,G4:G14,H5:I8,H9,G91:H280,G10:H88Cell Value=$P$39textNO
G3:H4,G4:G14,H5:I8,H9,G91:H280,G10:H88Cell Value=$P$37textNO
G3:H4,G4:G14,H5:I8,H9,G91:H280,G10:H88Cell Value=$P$36textNO
I19Cell Value=$P$42textNO
I19Cell Value=$P$41textNO
I19Cell Value=$P$40textNO
I19Cell Value=$P$39textNO
I19Cell Value=$P$37textNO
I19Cell Value=$P$36textNO
M3:O5Expression=COUNTIFS(XFB:XFB,L3,XFD:XFD,M3)>0textNO
N6:O7Expression=COUNTIFS(XFC:XFC,M6,#REF!,N6)>0textNO
E27:E29Expression=(E27="")*(D27<>"")textNO
E27:E29Expression=(E27="x")*(D27<>"")textNO
D29,D33Expression=COUNTIF(X:X,D29)>0textNO
D29,D33Expression=COUNTIF(XEV:XEV,D29)>0textNO
it is still not working. did i do somthing wrong when i entered the formula?
Click to expand...
nevermind. i figured out what i screwed up. thanks for the help
 
Upvote 0
You are welcome.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
copying adjacent cells based on value of referenced cell
Replies
4
Views
183
arun_eagertolearn
A
J
  • Solved
returning a value if multiple criteria are true
Replies
3
Views
338
etaf
etaf
J
  • Solved
conditional formatting with multiple criteria
Replies
8
Views
331
jbrown021286
J
J
  • Question
conditional formatting based on adjacent cells matching
Replies
1
Views
201
etaf
etaf
J
  • Question
sumif function with delayed application
Replies
5
Views
274
jbrown021286
J

Forum statistics

Threads
1,220,965
Messages
6,157,119
Members
451,398
Latest member
rjsteward

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top