SOLVED
Home

Mise en forme conditionnelle ou fonction ?

%3CLINGO-SUB%20id%3D%22lingo-sub-894227%22%20slang%3D%22fr-FR%22%3EConditional%20fitness%20or%20function%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-894227%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%20I'm%20a%20beginner%20in%20excel%2C%20I'm%20putting%20together%20a%20membership%20board%20for%20a%20club%2C%20and%20I%20have%202%20small%20questions%3A%3C%2FP%3E%3CP%3E1)%20I%20managed%20to%20set%20up%20conditional%20fitness%20and%20function!%20the%20worry%20when%20the%20boxes%20are%20empty%20it%20always%20marks%20me%20the%20same%20date%2031%2F12%2F1900%2C%20is%20it%20possible%20to%20remove%20this%20date%20by%20an%20empty%20box%20and%20without%20color%2C%20which%20will%20automatically%20fill%20when%20I%20have%20marked%20a%20date%20in%20the%20box%20%22payment%22%3F%26nbsp%3B%3C%2FP%3E%3CP%3E2)%20I%20would%20like%20to%20put%20on%20some%20box%20free%20memberships%2C%20is%20it%20possible%20to%20put%20%22free%22%20instead%20of%20the%20message%20%22VALEUR%22%20(see%20attachment).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-894227%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-894253%22%20slang%3D%22en-US%22%3ERe%3A%20Mise%20en%20forme%20conditionnelle%20ou%20fonction%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-894253%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420254%22%20target%3D%22_blank%22%3E%40Skafo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20English%20locale%20it%20could%20be%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIFERROR(IF(B2%3D%22%22%2C%22%22%2CEDATE(B2%2C12))%2C%22Gratuit%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EIf%20you%20open%20attached%20file%20it'll%20be%20in%20your%20locale%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-894306%22%20slang%3D%22fr-FR%22%3ERe%3A%20Conditional%20fitness%20or%20function%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-894306%22%20slang%3D%22fr-FR%22%3EThank%20you%20Well%20that's%20all%20i%20was%20looking%20for....%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-894319%22%20slang%3D%22en-US%22%3ERe%3A%20Mise%20en%20forme%20conditionnelle%20ou%20fonction%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-894319%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420254%22%20target%3D%22_blank%22%3E%40Skafo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDe%20rien%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Skafo
New Contributor

Bonjour je suis débutante en excel, je suis en train de mettre en place un tableau d'adhésion pour un club, et j'ai 2 petites questions :

1) j'ai réussi a mettre en place de mise en forme conditionnelle et de fonction! le souci quand les cases sont vides ça me marque toujours la même date 31/12/1900, est-ce possible de supprimé cette date par une case vide et sans couleur , qui ce remplira automatique quand j'aurai marqué une date dans la case "paiement"? 

2) je voudrais mettre sur certaine case des adhésions gratuites, est-ce que c'est possible de mettre "gratuit" a la place du message "VALEUR" (voir pièce jointe).

 

Cordialement

 

 

 

3 Replies
Solution

@Skafo 

In English locale it could be like

=IFERROR(IF(B2="","",EDATE(B2,12)),"Gratuit")

If you open attached file it'll be in your locale

Merci Bien c'est tout a fait ce que je recherchais....

@Skafo 

De rien !

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies