surlignage automatique

%3CLINGO-SUB%20id%3D%22lingo-sub-3011520%22%20slang%3D%22fr-FR%22%3Eauto%20highlighting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3011520%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI%20would%20like%20to%20know%20how%20to%20automate%20the%20highlighting%20of%20cells%20in%20a%20table%3C%2FP%3E%3CP%3EI%20have%208%20columns%2C%20I%20would%20like%20the%20cells%20to%20be%20highlighted%20when%20I%20enter%20the%20arrival%20date%20in%20the%20last%20column.%3C%2FP%3E%3CP%3Ethank%20you%20in%20advance%20for%20your%20help%3C%2FP%3E%3CP%3EKind%20regards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3011520%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3011597%22%20slang%3D%22en-US%22%3ERe%3A%20surlignage%20automatique%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3011597%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1231517%22%20target%3D%22_blank%22%3E%40bernard40%3C%2FA%3E%26nbsp%3BThat's%20done%20with%20Conditional%20Formatting.%20Added%20an%20example%20in%20the%20first%20sheet%20%22Janvier%22.%20The%20entire%20table%20row%20gets%20highlighted%20when%20something%20is%20entered%20in%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3011625%22%20slang%3D%22en-US%22%3ERe%3A%20surlignage%20automatique%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3011625%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1231517%22%20target%3D%22_blank%22%3E%40bernard40%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EYou%20can%20use%20conditional%20formatting%20my%20friend.%3CBR%20%2F%3E1.%20Select%20entire%20first%20row%3CBR%20%2F%3E2.%20Home%20-%26gt%3B%20Conditional%20Formatting%20-%26gt%3B%3CBR%20%2F%3E3.%20Choose%20New%20Rule%20-%26gt%3B%20Use%20a%20formula%20to%20determine%20which%20cells%20to%20format.%3CBR%20%2F%3E4.%20Enter%20the%20formula%20as%20below.%20I%20use%20DAY%20formula%20to%20determine%20whether%20an%20corresponding%20arrival%20date%20is%20blank%20or%20not.%20Be%20mindful%20to%20only%20lock%20the%20Column%2C%20not%20the%20Row%20(Press%20F4%20after%20you%20enter%20the%20Cell%20until%20you%20get%20the%20same%20result%20as%20below)%3CBR%20%2F%3E5.%20Choose%20a%20Format%20and%20press%20Ok.%20If%20you%20do%20this%20correctly%20you%20will%20see%20your%20row%20light%20up%20if%20it%20has%20arrival%20date.%3CBR%20%2F%3E6.%20Select%20the%20first%20row%2C%20point%20your%20mouse%20to%20the%20below%20right%20corner%20and%20drag%20all%20the%20way%20down%2C%20but%20choose%20to%20copy%20formatting%20only%20in%20the%20auto%20fill%20box.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Mike_Vu_Ngo_0-1638096758138.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329849iE55F432BCA0107C0%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Mike_Vu_Ngo_0-1638096758138.png%22%20alt%3D%22Mike_Vu_Ngo_0-1638096758138.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Mike_Vu_Ngo_1-1638097318915.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329853i62C89F0C30A6555C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Mike_Vu_Ngo_1-1638097318915.png%22%20alt%3D%22Mike_Vu_Ngo_1-1638097318915.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

bonjour

je voudrais savoir comment automatiser le surlignage de cellules dans un tableau

 j'ai 8 colonnes, je voudrais que les cellules soit surligner quand je saisi la date d'arrivage dans la dernière colonnes.

je vous remercie d'avance pour votre aide

cordialement

 

4 Replies

@bernard40 That's done with Conditional Formatting. Added an example in the first sheet "Janvier". The entire table row gets highlighted when something is entered in column I. 

@bernard40 
You can use conditional formatting my friend.
1. Select entire first row
2. Home -> Conditional Formatting ->
3. Choose New Rule -> Use a formula to determine which cells to format.
4. Enter the formula as below. I use DAY formula to determine whether an corresponding arrival date is blank or not. Be mindful to only lock the Column, not the Row (Press F4 after you enter the Cell until you get the same result as below)
5. Choose a Format and press Ok. If you do this correctly you will see your row light up if it has arrival date.
6. Select the first row, point your mouse to the below right corner and drag all the way down, but choose to copy formatting only in the auto fill box.

Mike_Vu_Ngo_0-1638096758138.png

Mike_Vu_Ngo_1-1638097318915.png

 

 

je vous remercie pour votre aide

@bernard40 

As a cosmetic comment, I'd simplify conditional formatting rule formula to

=$J2