Formatage de cellule dans excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1841016%22%20slang%3D%22fr-FR%22%3ECell%20formatting%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1841016%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI%20want%20to%20evolve%20an%20excel%20cell%20coloration%20as%20the%20percentage%20of%20the%20cell%20increases.%20The%20color%20should%20be%20zero%20at%200%25%20and%20progress%20to%20be%20total%20green%20at%20100%25%20value.%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20support%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1841016%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1841094%22%20slang%3D%22de-DE%22%3ESubject%3A%20Formatage%20de%20cellule%20dans%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1841094%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F852850%22%20target%3D%22_blank%22%3E%40Dinkedebisson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EWith%20your%20permission%2C%20here%20is%20some%20information%20in%20French%20about%20Conditional%20Formatting.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EWith%20this%20information%20you%20can%20learn%20which%20cell%20you%20want%20and%20color%20it%20according%20to%20your%20specifications.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3EAppliquer%20la%20mise%20en%20forme%20conditionnelle%20pour%20faire%20ressortir%20des%20informations%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Ffr-fr%2Foffice%2Fappliquer-la-mise-en-forme-conditionnelle-pour-faire-ressortir-des-informations-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f%3Fui%3Dfr-fr%26amp%3Brs%3Dfr-fr%26amp%3Bad%3Dfr%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Ffr-fr%2Foffice%2Fappliquer-la-mise-en-forme-conditionnelle-pour-faire-ressortir-des-informations-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f%3Fui%3Dfr-fr%26amp%3Brs%3Dfr-fr%26amp%3Bad%3Dfr%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EJ'esp%C3%A9re%20que%20j'ai%20pu%20vous%20aider%20et%20je%20serais%20heureux%20de%20savoir%20si%20je%20pouvais%20vous%20aider.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3ENikolino%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EJe%20sais%20que%20je%20ne%20sais%20rien%20(Socrate)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3E*%20Veuillez%20marquer%20et%20voter%20pour%20cette%20r%C3%A9ponse%20si%20cela%20vous%20aide%2C%20car%20cela%20sera%20b%C3%A9n%C3%A9fique%20pour%20plus%20de%20membres%20de%20la%20communaut%C3%A9%20qui%20liront%20ici%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Bonjour,

Je veux faire évoluer une coloration d'une cellule excel au fur et à mesure que le pourcentage de la cellule augmente. Le couleur doit être nulle à 0% et progresser jusqu'à être vert total à la valeur de 100%.

Merci pour votre support

1 Reply

@Dinkedebisson 

With your permission, here is some information in French about Conditional Formatting.

With this information you can learn which cell you want and color it according to your specifications.

 

Appliquer la mise en forme conditionnelle pour faire ressortir des informations

https://support.microsoft.com/fr-fr/office/appliquer-la-mise-en-forme-conditionnelle-pour-faire-ress...

 

J'espère que j'ai pu vous aider et je serais heureux de savoir si je pouvais vous aider.

Nikolino
Je sais que je ne sais rien (Socrate)

* Veuillez marquer et voter pour cette réponse si cela vous aide, car cela sera bénéfique pour plus de membres de la communauté qui liront ici