formatage conditionnel [closed]

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

jmvantieghem
1 ●1 ●1 ●1

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

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-09 22:15:38.508026

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 ( 2017-07-16 18:34:37 +0100 )edit

add a comment

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

charlie.it

1722 ●17 ●24 ●44 http://www.charlieopen...

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

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

1 - Create a new style of cell "Yellow"

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

add a comment

formatage conditionnel [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-09 22:15:38.508026

Comments

1 Answer

Question Tools

Stats

Related questions

formatage conditionnel [closed] edit

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2020-10-09 22:15:38.508026

Comments

1 Answer

Question Tools

Stats

Related questions

formatage conditionnel [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-09 22:15:38.508026