Ask Your Question
0

formatage conditionnel

asked 2017-07-16 17:33:25 +0200

jmvantieghem gravatar image

comment formater une ou plusieurs cellules en fonction d'une condition sur une autre cellule exemple : si B1 = "dimanche" alors (B1 et C1 ) sont colorées en arrière plan en jaune

merci pour votre collaboration Jean-Marc

edit retag flag offensive close merge delete

Comments

How to format one or more cells based on a condition from another cell, example : if B1 = "sunday" then (B1 and C1) get a yellow background color.

thanks for your collaboration Jean-Marc

librebel gravatar imagelibrebel ( 2017-07-16 18:34:37 +0200 )edit

1 Answer

Sort by » oldest newest most voted
2

answered 2017-07-16 19:31:42 +0200

updated 2017-07-16 19:35:52 +0200

If my answer helped you, vote it with ✔ (here on the left)

1 - Create a new style of cell "Yellow"

image description image description

2 - For cell B1: Format > Conditional formatting > Conditions ...

image description

3 - For cell C1: Format > Conditional formatting > Conditions ...

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-07-16 17:33:25 +0200

Seen: 36 times

Last updated: Jul 16