SOLVED

Hoe kan ik een cel met een negatieve % in andere kleur zetten is standaard zwart?

%3CLINGO-SUB%20id%3D%22lingo-sub-1564747%22%20slang%3D%22en-US%22%3EHoe%20kan%20ik%20een%20cel%20met%20een%20negatieve%20%25%20in%20andere%20kleur%20zetten%20is%20standaard%20zwart%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564747%22%20slang%3D%22en-US%22%3E%3CP%3EHelp!%26nbsp%3B%20Na%20het%20verschil%20tussen%202%20cellen%20(getal)%20wil%20ik%20in%20een%20andere%20cel%20resultaat%20in%20%25.%3C%2FP%3E%3CP%3E%3CSTRONG%3EMaar%20bij%20dit%20getal%20is%20het%20niet%20meer%20mogelijk.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22428%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2275%22%3EGetal%201%3C%2FTD%3E%3CTD%20width%3D%2275%22%3EGetal%202%3C%2FTD%3E%3CTD%20width%3D%2275%22%3EVerschil%201%20%26amp%3B%202%3C%2FTD%3E%3CTD%20width%3D%2275%22%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%25%20verschil%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E439%2C99%3C%2FTD%3E%3CTD%3E451%3C%2FTD%3E%3CTD%3E11%2C01%3C%2FTD%3E%3CTD%3E2%2C50%25%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E200%2C00%3C%2FTD%3E%3CTD%3E226%3C%2FTD%3E%3CTD%3E26%2C00%3C%2FTD%3E%3CTD%3E13%2C00%25%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E200%2C63%3C%2FTD%3E%3CTD%3E167%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23FF0000%22%3E-33%2C63%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E%3CFONT%20color%3D%22%23FF0000%22%3E-0%2C17%25%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E%3CFONT%20color%3D%22%23FF0000%22%3Eresultaat%20%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E201%2C00%3C%2FTD%3E%3CTD%3E150%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23FF0000%22%3E-51%2C00%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E-25%2C37%25%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E108%2C13%3C%2FTD%3E%3CTD%3E118%3C%2FTD%3E%3CTD%3E9%2C87%3C%2FTD%3E%3CTD%3E9%2C13%25%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E150%2C00%3C%2FTD%3E%3CTD%3E153%3C%2FTD%3E%3CTD%3E3%2C00%3C%2FTD%3E%3CTD%3E2%2C00%25%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E100%2C00%3C%2FTD%3E%3CTD%3E102%3C%2FTD%3E%3CTD%3E2%2C00%3C%2FTD%3E%3CTD%3E2%2C00%25%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E150%2C00%3C%2FTD%3E%3CTD%3E147%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23FF0000%22%3E-3%2C00%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E-2%2C00%25%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E190%2C59%3C%2FTD%3E%3CTD%3E198%3C%2FTD%3E%3CTD%3E7%2C41%3C%2FTD%3E%3CTD%3E3%2C89%25%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E175%2C00%3C%2FTD%3E%3CTD%3E165%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23FF0000%22%3E-10%2C00%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E-5%2C71%25%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E94%2C75%3C%2FTD%3E%3CTD%3E128%3C%2FTD%3E%3CTD%3E33%2C25%3C%2FTD%3E%3CTD%3E35%2C09%25%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E45%2C00%3C%2FTD%3E%3CTD%3E35%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23FF0000%22%3E-10%2C00%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E-22%2C22%25%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1564747%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1564831%22%20slang%3D%22en-US%22%3ERe%3A%20Hoe%20kan%20ik%20een%20cel%20met%20een%20negatieve%20%25%20in%20andere%20kleur%20zetten%20is%20standaard%20zwart%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564831%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F464230%22%20target%3D%22_blank%22%3E%40verlindenlucproximus%3C%2FA%3E%26nbsp%3BUse%20a%20custom%20format%20like%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E0%25%3B%5BRed%5D-0%25%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1564879%22%20slang%3D%22en-US%22%3ERe%3A%20Hoe%20kan%20ik%20een%20cel%20met%20een%20negatieve%20%25%20in%20andere%20kleur%20zetten%20is%20standaard%20zwart%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564879%22%20slang%3D%22en-US%22%3EHartelijk%20dank%2C%20mijn%20probleem%20opgelost%3C%2FLINGO-BODY%3E
New Contributor

Help!  Na het verschil tussen 2 cellen (getal) wil ik in een andere cel resultaat in %.

Maar bij dit getal is het niet meer mogelijk.

 

 Getal 1Getal 2Verschil 1 & 2

    % verschil

 

 439,9945111,012,50% 
 200,0022626,0013,00% 
 200,63167-33,63-0,17%resultaat
 201,00150-51,00-25,37% 
 108,131189,879,13% 
 150,001533,002,00% 
 100,001022,002,00% 
 150,00147-3,00-2,00% 
 190,591987,413,89% 
 175,00165-10,00-5,71% 
 94,7512833,2535,09% 
 45,0035-10,00-22,22% 
      
      
      
2 Replies
Best Response confirmed by verlindenlucproximus (New Contributor)
Solution

@verlindenlucproximus Use a custom format like:

 

0%;[Red]-0%

 

 

Hartelijk dank, mijn probleem opgelost