SOLVED

how to inter formula in a cell has more 8192 characters

%3CLINGO-SUB%20id%3D%22lingo-sub-2142505%22%20slang%3D%22en-US%22%3Ehow%20to%20inter%20formula%20in%20a%20cell%20has%20more%208192%20characters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2142505%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%20guys%3C%2FP%3E%3CP%3EI%20am%20using%20office%202019%3C%2FP%3E%3CP%3EI%20tried%20to%20maintain%20our%20work%20activity%20progress%20in%20the%20project%20by%20making%20a%20tracking%20plane%20depending%20on%20the%20entry%20data%20we%20have%20provided%20it%20in%20another%20sheet%20table%3C%2FP%3E%3CP%3Efor%20an%20example%3A%3C%2FP%3E%3CP%3EI%20have%20a%20finished%20work%20along%20alignment%20from%3C%2FP%3E%3CP%3Estation%20%3A%200%2B300%20to%200%2B500%3C%2FP%3E%3CP%3Eand%20from%26nbsp%3B%3C%2FP%3E%3CP%3Estation%20%3A%200%2B700%20to%200%2B900%3C%2FP%3E%3CP%3Ei%20would%20like%20highlight%20the%20cells%20under%20my%20station's%20dividing%20in%20the%20sheet%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22alexanderjaml_0-1613557486362.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F255476iD4A79850D1367777%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22alexanderjaml_0-1613557486362.png%22%20alt%3D%22alexanderjaml_0-1613557486362.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20have%20used%20this%20formula%20and%20it%20was%20successful%3A%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%221%202%203%204%205%206%207%22%20color%3D%22%230000FF%22%3E%3DIF(OR(AND(A%241%26gt%3B%3DBEDDING!%24A%241%2CA%241%26lt%3B%3DBEDDING!%24B%241)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%242%2CA%241%26lt%3B%3DBEDDING!%24B%242)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%243%2CA%241%26lt%3B%3DBEDDING!%24B%243)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%244%2CA%241%26lt%3B%3DBEDDING!%24B%244)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%245%2CA%241%26lt%3B%3DBEDDING!%24B%245)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%246%2CA%241%26lt%3B%3DBEDDING!%24B%246)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%247%2CA%241%26lt%3B%3DBEDDING!%24B%247)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%248%2CA%241%26lt%3B%3DBEDDING!%24B%248)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%249%2CA%241%26lt%3B%3DBEDDING!%24B%249)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2410%2CA%241%26lt%3B%3DBEDDING!%24B%2410)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2411%2CA%241%26lt%3B%3DBEDDING!%24B%2411)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2412%2CA%241%26lt%3B%3DBEDDING!%24B%2412)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2413%2CA%241%26lt%3B%3DBEDDING!%24B%2413)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2414%2CA%241%26lt%3B%3DBEDDING!%24B%2414)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2415%2CA%241%26lt%3B%3DBEDDING!%24B%2415)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2416%2CA%241%26lt%3B%3DBEDDING!%24B%2416)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2417%2CA%241%26lt%3B%3DBEDDING!%24B%2417)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2418%2CA%241%26lt%3B%3DBEDDING!%24B%2418)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2419%2CA%241%26lt%3B%3DBEDDING!%24B%2419)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2420%2CA%241%26lt%3B%3DBEDDING!%24B%2420)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2421%2CA%241%26lt%3B%3DBEDDING!%24B%2421)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2422%2CA%241%26lt%3B%3DBEDDING!%24B%2422)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2423%2CA%241%26lt%3B%3DBEDDING!%24B%2423)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2424%2CA%241%26lt%3B%3DBEDDING!%24B%2424)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2425%2CA%241%26lt%3B%3DBEDDING!%24B%2425)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2426%2CA%241%26lt%3B%3DBEDDING!%24B%2426)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2427%2CA%241%26lt%3B%3DBEDDING!%24B%2427)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2428%2CA%241%26lt%3B%3DBEDDING!%24B%2428)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2429%2CA%241%26lt%3B%3DBEDDING!%24B%2429)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2430%2CA%241%26lt%3B%3DBEDDING!%24B%2430)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2431%2CA%241%26lt%3B%3DBEDDING!%24B%2431)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2432%2CA%241%26lt%3B%3DBEDDING!%24B%2432)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2433%2CA%241%26lt%3B%3DBEDDING!%24B%2433)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2434%2CA%241%26lt%3B%3DBEDDING!%24B%2434)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2435%2CA%241%26lt%3B%3DBEDDING!%24B%2435)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2436%2CA%241%26lt%3B%3DBEDDING!%24B%2436)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2437%2CA%241%26lt%3B%3DBEDDING!%24B%2437)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2438%2CA%241%26lt%3B%3DBEDDING!%24B%2438)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2439%2CA%241%26lt%3B%3DBEDDING!%24B%2439)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2440%2CA%241%26lt%3B%3DBEDDING!%24B%2440)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2441%2CA%241%26lt%3B%3DBEDDING!%24B%2441)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2442%2CA%241%26lt%3B%3DBEDDING!%24B%2442)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2443%2CA%241%26lt%3B%3DBEDDING!%24B%2443)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2444%2CA%241%26lt%3B%3DBEDDING!%24B%2444)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2445%2CA%241%26lt%3B%3DBEDDING!%24B%2445)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2446%2CA%241%26lt%3B%3DBEDDING!%24B%2446)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2447%2CA%241%26lt%3B%3DBEDDING!%24B%2447)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2448%2CA%241%26lt%3B%3DBEDDING!%24B%2448)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2449%2CA%241%26lt%3B%3DBEDDING!%24B%2449)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2450%2CA%241%26lt%3B%3DBEDDING!%24B%2450)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2451%2CA%241%26lt%3B%3DBEDDING!%24B%2451)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2452%2CA%241%26lt%3B%3DBEDDING!%24B%2452)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2453%2CA%241%26lt%3B%3DBEDDING!%24B%2453)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2454%2CA%241%26lt%3B%3DBEDDING!%24B%2454)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2455%2CA%241%26lt%3B%3DBEDDING!%24B%2455)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2456%2CA%241%26lt%3B%3DBEDDING!%24B%2456)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2457%2CA%241%26lt%3B%3DBEDDING!%24B%2457)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2458%2CA%241%26lt%3B%3DBEDDING!%24B%2458)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2459%2CA%241%26lt%3B%3DBEDDING!%24B%2459)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2460%2CA%241%26lt%3B%3DBEDDING!%24B%2460)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2461%2CA%241%26lt%3B%3DBEDDING!%24B%2461)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2462%2CA%241%26lt%3B%3DBEDDING!%24B%2462)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2463%2CA%241%26lt%3B%3DBEDDING!%24B%2463)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2464%2CA%241%26lt%3B%3DBEDDING!%24B%2464)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2465%2CA%241%26lt%3B%3DBEDDING!%24B%2465)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2466%2CA%241%26lt%3B%3DBEDDING!%24B%2466)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2467%2CA%241%26lt%3B%3DBEDDING!%24B%2467)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2468%2CA%241%26lt%3B%3DBEDDING!%24B%2468)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2469%2CA%241%26lt%3B%3DBEDDING!%24B%2469)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2470%2CA%241%26lt%3B%3DBEDDING!%24B%2470)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2471%2CA%241%26lt%3B%3DBEDDING!%24B%2471)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2472%2CA%241%26lt%3B%3DBEDDING!%24B%2472)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2473%2CA%241%26lt%3B%3DBEDDING!%24B%2473)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2474%2CA%241%26lt%3B%3DBEDDING!%24B%2474)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2475%2CA%241%26lt%3B%3DBEDDING!%24B%2475)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2476%2CA%241%26lt%3B%3DBEDDING!%24B%2476)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2477%2CA%241%26lt%3B%3DBEDDING!%24B%2477)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2478%2CA%241%26lt%3B%3DBEDDING!%24B%2478)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2479%2CA%241%26lt%3B%3DBEDDING!%24B%2479)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2480%2CA%241%26lt%3B%3DBEDDING!%24B%2480)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2481%2CA%241%26lt%3B%3DBEDDING!%24B%2481)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2482%2CA%241%26lt%3B%3DBEDDING!%24B%2482)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2483%2CA%241%26lt%3B%3DBEDDING!%24B%2483)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2484%2CA%241%26lt%3B%3DBEDDING!%24B%2484)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2485%2CA%241%26lt%3B%3DBEDDING!%24B%2485)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2486%2CA%241%26lt%3B%3DBEDDING!%24B%2486)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2487%2CA%241%26lt%3B%3DBEDDING!%24B%2487)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2488%2CA%241%26lt%3B%3DBEDDING!%24B%2488)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2489%2CA%241%26lt%3B%3DBEDDING!%24B%2489)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2490%2CA%241%26lt%3B%3DBEDDING!%24B%2490)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2491%2CA%241%26lt%3B%3DBEDDING!%24B%2491)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2492%2CA%241%26lt%3B%3DBEDDING!%24B%2492)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2493%2CA%241%26lt%3B%3DBEDDING!%24B%2493)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2494%2CA%241%26lt%3B%3DBEDDING!%24B%2494)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2495%2CA%241%26lt%3B%3DBEDDING!%24B%2495)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2496%2CA%241%26lt%3B%3DBEDDING!%24B%2496)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2497%2CA%241%26lt%3B%3DBEDDING!%24B%2497)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2498%2CA%241%26lt%3B%3DBEDDING!%24B%2498)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%2499%2CA%241%26lt%3B%3DBEDDING!%24B%2499)%2CAND(A%241%26gt%3B%3DBEDDING!%24A%24100%2CA%241%26lt%3B%3DBEDDING!%24B%24100))%2C1%2C0)%3C%2FFONT%3E%3C%2FP%3E%3CP%3Ebut%20I%20can't%20enter%20character%20more%20than%208192%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22alexanderjaml_1-1613557919973.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F255480i85012E63554CDC3B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22alexanderjaml_1-1613557919973.png%22%20alt%3D%22alexanderjaml_1-1613557919973.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20is%20there%20any%20solution%20for%20it%20or%20other%20way%20to%20solve%20it%3C%2FP%3E%3CP%3Ebest%20regards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2142505%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2142687%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20inter%20formula%20in%20a%20cell%20has%20more%208192%20characters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2142687%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F969308%22%20target%3D%22_blank%22%3E%40alexanderjaml%3C%2FA%3E%26nbsp%3BCan%20you%20disclose%20what%20you%20have%20in%20the%20BEDDING%20sheet%20and%20what%20output%20you%20expect%20in%20the%20progress%20chart%3F%20I'm%20pretty%20sure%20you%20don't%20need%20such%20a%20monstrous%20formula%20for%20whatever%20you%20are%20trying%20to%20do.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2144423%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20inter%20formula%20in%20a%20cell%20has%20more%208192%20characters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2144423%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F969308%22%20target%3D%22_blank%22%3E%40alexanderjaml%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHere%20are%20two%20different%20questions%3C%2FP%3E%0A%3CP%3E1)%20how%20to%20highlight%20some%20cells%3C%2FP%3E%0A%3CP%3E2)%20how%20to%20apply%20the%20formula%20in%20sample%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFirst%20question%20-%20didn't%20catch%20the%20logic%2C%20not%20sure%3C%2FP%3E%0A%3CP%3ESecond%20question%20-%20use%20alternative%20formula%20which%20returns%20desired%20result.%20It%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3D--(SUMPRODUCT(%20(A%241%26gt%3B%3DBedding!%24A%241%3AA%24100)*(A%241%26lt%3B%3DBedding!%24B%241%3AB%24100))%26gt%3B0)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor

hello guys

I am using office 2019

I tried to maintain our work activity progress in the project by making a tracking plane depending on the entry data we have provided it in another sheet table

for an example:

I have a finished work along alignment from

station : 0+300 to 0+500

and from 

station : 0+700 to 0+900

i would like highlight the cells under my station's dividing in the sheet

alexanderjaml_0-1613557486362.png

I have used this formula and it was successful:

=IF(OR(AND(A$1>=BEDDING!$A$1,A$1<=BEDDING!$B$1),AND(A$1>=BEDDING!$A$2,A$1<=BEDDING!$B$2),AND(A$1>=BEDDING!$A$3,A$1<=BEDDING!$B$3),AND(A$1>=BEDDING!$A$4,A$1<=BEDDING!$B$4),AND(A$1>=BEDDING!$A$5,A$1<=BEDDING!$B$5),AND(A$1>=BEDDING!$A$6,A$1<=BEDDING!$B$6),AND(A$1>=BEDDING!$A$7,A$1<=BEDDING!$B$7),AND(A$1>=BEDDING!$A$8,A$1<=BEDDING!$B$8),AND(A$1>=BEDDING!$A$9,A$1<=BEDDING!$B$9),AND(A$1>=BEDDING!$A$10,A$1<=BEDDING!$B$10),AND(A$1>=BEDDING!$A$11,A$1<=BEDDING!$B$11),AND(A$1>=BEDDING!$A$12,A$1<=BEDDING!$B$12),AND(A$1>=BEDDING!$A$13,A$1<=BEDDING!$B$13),AND(A$1>=BEDDING!$A$14,A$1<=BEDDING!$B$14),AND(A$1>=BEDDING!$A$15,A$1<=BEDDING!$B$15),AND(A$1>=BEDDING!$A$16,A$1<=BEDDING!$B$16),AND(A$1>=BEDDING!$A$17,A$1<=BEDDING!$B$17),AND(A$1>=BEDDING!$A$18,A$1<=BEDDING!$B$18),AND(A$1>=BEDDING!$A$19,A$1<=BEDDING!$B$19),AND(A$1>=BEDDING!$A$20,A$1<=BEDDING!$B$20),AND(A$1>=BEDDING!$A$21,A$1<=BEDDING!$B$21),AND(A$1>=BEDDING!$A$22,A$1<=BEDDING!$B$22),AND(A$1>=BEDDING!$A$23,A$1<=BEDDING!$B$23),AND(A$1>=BEDDING!$A$24,A$1<=BEDDING!$B$24),AND(A$1>=BEDDING!$A$25,A$1<=BEDDING!$B$25),AND(A$1>=BEDDING!$A$26,A$1<=BEDDING!$B$26),AND(A$1>=BEDDING!$A$27,A$1<=BEDDING!$B$27),AND(A$1>=BEDDING!$A$28,A$1<=BEDDING!$B$28),AND(A$1>=BEDDING!$A$29,A$1<=BEDDING!$B$29),AND(A$1>=BEDDING!$A$30,A$1<=BEDDING!$B$30),AND(A$1>=BEDDING!$A$31,A$1<=BEDDING!$B$31),AND(A$1>=BEDDING!$A$32,A$1<=BEDDING!$B$32),AND(A$1>=BEDDING!$A$33,A$1<=BEDDING!$B$33),AND(A$1>=BEDDING!$A$34,A$1<=BEDDING!$B$34),AND(A$1>=BEDDING!$A$35,A$1<=BEDDING!$B$35),AND(A$1>=BEDDING!$A$36,A$1<=BEDDING!$B$36),AND(A$1>=BEDDING!$A$37,A$1<=BEDDING!$B$37),AND(A$1>=BEDDING!$A$38,A$1<=BEDDING!$B$38),AND(A$1>=BEDDING!$A$39,A$1<=BEDDING!$B$39),AND(A$1>=BEDDING!$A$40,A$1<=BEDDING!$B$40),AND(A$1>=BEDDING!$A$41,A$1<=BEDDING!$B$41),AND(A$1>=BEDDING!$A$42,A$1<=BEDDING!$B$42),AND(A$1>=BEDDING!$A$43,A$1<=BEDDING!$B$43),AND(A$1>=BEDDING!$A$44,A$1<=BEDDING!$B$44),AND(A$1>=BEDDING!$A$45,A$1<=BEDDING!$B$45),AND(A$1>=BEDDING!$A$46,A$1<=BEDDING!$B$46),AND(A$1>=BEDDING!$A$47,A$1<=BEDDING!$B$47),AND(A$1>=BEDDING!$A$48,A$1<=BEDDING!$B$48),AND(A$1>=BEDDING!$A$49,A$1<=BEDDING!$B$49),AND(A$1>=BEDDING!$A$50,A$1<=BEDDING!$B$50),AND(A$1>=BEDDING!$A$51,A$1<=BEDDING!$B$51),AND(A$1>=BEDDING!$A$52,A$1<=BEDDING!$B$52),AND(A$1>=BEDDING!$A$53,A$1<=BEDDING!$B$53),AND(A$1>=BEDDING!$A$54,A$1<=BEDDING!$B$54),AND(A$1>=BEDDING!$A$55,A$1<=BEDDING!$B$55),AND(A$1>=BEDDING!$A$56,A$1<=BEDDING!$B$56),AND(A$1>=BEDDING!$A$57,A$1<=BEDDING!$B$57),AND(A$1>=BEDDING!$A$58,A$1<=BEDDING!$B$58),AND(A$1>=BEDDING!$A$59,A$1<=BEDDING!$B$59),AND(A$1>=BEDDING!$A$60,A$1<=BEDDING!$B$60),AND(A$1>=BEDDING!$A$61,A$1<=BEDDING!$B$61),AND(A$1>=BEDDING!$A$62,A$1<=BEDDING!$B$62),AND(A$1>=BEDDING!$A$63,A$1<=BEDDING!$B$63),AND(A$1>=BEDDING!$A$64,A$1<=BEDDING!$B$64),AND(A$1>=BEDDING!$A$65,A$1<=BEDDING!$B$65),AND(A$1>=BEDDING!$A$66,A$1<=BEDDING!$B$66),AND(A$1>=BEDDING!$A$67,A$1<=BEDDING!$B$67),AND(A$1>=BEDDING!$A$68,A$1<=BEDDING!$B$68),AND(A$1>=BEDDING!$A$69,A$1<=BEDDING!$B$69),AND(A$1>=BEDDING!$A$70,A$1<=BEDDING!$B$70),AND(A$1>=BEDDING!$A$71,A$1<=BEDDING!$B$71),AND(A$1>=BEDDING!$A$72,A$1<=BEDDING!$B$72),AND(A$1>=BEDDING!$A$73,A$1<=BEDDING!$B$73),AND(A$1>=BEDDING!$A$74,A$1<=BEDDING!$B$74),AND(A$1>=BEDDING!$A$75,A$1<=BEDDING!$B$75),AND(A$1>=BEDDING!$A$76,A$1<=BEDDING!$B$76),AND(A$1>=BEDDING!$A$77,A$1<=BEDDING!$B$77),AND(A$1>=BEDDING!$A$78,A$1<=BEDDING!$B$78),AND(A$1>=BEDDING!$A$79,A$1<=BEDDING!$B$79),AND(A$1>=BEDDING!$A$80,A$1<=BEDDING!$B$80),AND(A$1>=BEDDING!$A$81,A$1<=BEDDING!$B$81),AND(A$1>=BEDDING!$A$82,A$1<=BEDDING!$B$82),AND(A$1>=BEDDING!$A$83,A$1<=BEDDING!$B$83),AND(A$1>=BEDDING!$A$84,A$1<=BEDDING!$B$84),AND(A$1>=BEDDING!$A$85,A$1<=BEDDING!$B$85),AND(A$1>=BEDDING!$A$86,A$1<=BEDDING!$B$86),AND(A$1>=BEDDING!$A$87,A$1<=BEDDING!$B$87),AND(A$1>=BEDDING!$A$88,A$1<=BEDDING!$B$88),AND(A$1>=BEDDING!$A$89,A$1<=BEDDING!$B$89),AND(A$1>=BEDDING!$A$90,A$1<=BEDDING!$B$90),AND(A$1>=BEDDING!$A$91,A$1<=BEDDING!$B$91),AND(A$1>=BEDDING!$A$92,A$1<=BEDDING!$B$92),AND(A$1>=BEDDING!$A$93,A$1<=BEDDING!$B$93),AND(A$1>=BEDDING!$A$94,A$1<=BEDDING!$B$94),AND(A$1>=BEDDING!$A$95,A$1<=BEDDING!$B$95),AND(A$1>=BEDDING!$A$96,A$1<=BEDDING!$B$96),AND(A$1>=BEDDING!$A$97,A$1<=BEDDING!$B$97),AND(A$1>=BEDDING!$A$98,A$1<=BEDDING!$B$98),AND(A$1>=BEDDING!$A$99,A$1<=BEDDING!$B$99),AND(A$1>=BEDDING!$A$100,A$1<=BEDDING!$B$100)),1,0)

but I can't enter character more than 8192

alexanderjaml_1-1613557919973.png

 

so is there any solution for it or other way to solve it

best regards

5 Replies

@alexanderjaml Can you disclose what you have in the BEDDING sheet and what output you expect in the progress chart? I'm pretty sure you don't need such a monstrous formula for whatever you are trying to do.

Best Response confirmed by alexanderjaml (New Contributor)
Solution

@alexanderjaml 

Here are two different questions

1) how to highlight some cells

2) how to apply the formula in sample

 

First question - didn't catch the logic, not sure

Second question - use alternative formula which returns desired result. It could be

=--(SUMPRODUCT( (A$1>=Bedding!$A$1:A$100)*(A$1<=Bedding!$B$1:B$100))>0)

yeah i find it 

thank u so much @Riny_van_Eekelen 

=--(SUMPRODUCT( (A$1>=Bedding!$A$1:A$100)*(A$1<=Bedding!$B$1:B$100))>0)

thank you i appreciate your help

It works well@Sergei Baklan 

@alexanderjaml , glad to know it helped