Home

duplication de la fonction "validation" d'une cellule avec excel

%3CLINGO-SUB%20id%3D%22lingo-sub-756618%22%20slang%3D%22en-US%22%3Eduplication%20de%20la%20fonction%20%22validation%22%20d'une%20cellule%20avec%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-756618%22%20slang%3D%22en-US%22%3E%3CP%3Ebonjour%20je%20cherche%20%C3%A0%20bloquer%20certaines%20cellules%20en%20fonction%20d'une%20valeur%20%22plafond%22%20%C3%A0%20ne%20pas%20d%C3%A9passer.%20J'ai%20trouv%C3%A9%20une%20%C3%A9criture%20avec%26nbsp%3B%20la%20validation%20de%20donn%C3%A9es%20qui%20semble%20me%20donner%26nbsp%3B%20satisfaction%20et%20qui%20introduit%20le%20signe%20%24%3C%2FP%3E%3CP%3Epar%20exemple%20dans%20la%20zone%20%22conditions%22%20de%20validatio%20nde%20donn%C3%A9es%2C%20j'%C3%A9cris%20%22suivi%20cours%20clients%22%24h%242%26gt%3B%3D0%3C%2FP%3E%3CP%3Emais%20mon%20souci%20arrive%20quand%20je%20veux%20dupliquer%20ou%20copier%20coller%20la%20formule%20dans%20les%20autres%20cellules%3C%2FP%3E%3CP%3Edans%20l'onglet%20%22octobre%22%26nbsp%3B%3C%2FP%3E%3CP%3Eligne%202%20il%20faut%20%22suivi%20cours%20clients%22%24h%242%26gt%3B%3D0%3C%2FP%3E%3CP%3Epuis%20ligne%203%20....%20%22suivi%20cours%20clients%22%24h%243%26gt%3B%3D0%3C%2FP%3E%3CP%3Epuis%20ligne%204%20....%20%22suivi%20cours%20clients%22%24h%244%26gt%3B%3D0%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eet%20ainsi%20de%20suite%20jusqu'%C3%A0%20la%20ligne%20120%20!%3C%2FP%3E%3CP%3Eet%20%C3%A0%20cette%20%C3%A9tape%20je%20bugge%20car%20la%20%22croix%20qui%20recopie%22%20ou%20la%20fonction%20copier%20%2F%20collage%20sp%C3%A9cial%2F%20formule%20garde%20la%20cellule%20H2%20(sans%20doute%20%C3%A0%20cause%20du%20signe%20%24)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-756618%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-790474%22%20slang%3D%22en-US%22%3ERe%3A%20duplication%20de%20la%20fonction%20%22validation%22%20d'une%20cellule%20avec%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-790474%22%20slang%3D%22en-US%22%3EFor%20the%20cell%20H2%2C%20you%20would%20want%20the%20condition%20to%20be%20%24H2%26gt%3B%3D0.%20Then%20as%20you%20copy%20down%2C%20the%20column%20H%20would%20be%20locked%20but%20the%20row%20numbers%20can%20move%20freely.%3C%2FLINGO-BODY%3E
laurentperat
Occasional Visitor

bonjour je cherche à bloquer certaines cellules en fonction d'une valeur "plafond" à ne pas dépasser. J'ai trouvé une écriture avec  la validation de données qui semble me donner  satisfaction et qui introduit le signe $

par exemple dans la zone "conditions" de validatio nde données, j'écris "suivi cours clients"$h$2>=0

mais mon souci arrive quand je veux dupliquer ou copier coller la formule dans les autres cellules

dans l'onglet "octobre" 

ligne 2 il faut "suivi cours clients"$h$2>=0

puis ligne 3 .... "suivi cours clients"$h$3>=0

puis ligne 4 .... "suivi cours clients"$h$4>=0

 

et ainsi de suite jusqu'à la ligne 120 !

et à cette étape je bugge car la "croix qui recopie" ou la fonction copier / collage spécial/ formule garde la cellule H2 (sans doute à cause du signe $)

 

1 Reply
For the cell H2, you would want the condition to be $H2>=0. Then as you copy down, the column H would be locked but the row numbers can move freely.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies