formatage conditionnel

calc

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

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

add a comment

1 Answer

Sort by » oldest newest most voted

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

charlie.it

1172 ●13 ●22 ●40 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

Question Tools

1 follower

Stats

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

Seen: 135 times

Last updated: Jul 16 '17

formatage conditionnel edit

Comments

1 Answer

Question Tools

Stats

Related questions

formatage conditionnel