Forum Discussion
surlignage automatique
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 dern...
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.