How to automate to arrange colors depending on cell contents?

B

Bartiwka2018-05-09 06:32:47

excel

Bartiwka, 2018-05-09 06:32:47

There are two columns in the first value (yes, no) in the second color column (gray is yes, and white if not) The question is how to automate so that the colors are arranged depending on the contents of the cell in column 1, while the value itself is in the first column
' change places! If not difficult, you can with examples! Thank you!

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

K

kalapanga, 2018-05-09
@Bartiwka

This is done by conditional formatting. Select column B. Next Home - Conditional Formatting - Create Rule... and so on. The rule will be like if $A1="yes" then the format is gray fill