How to automate to arrange colors depending on cell contents?

Question

excel

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!

Answer 1

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