I am trying to make excel sheet where there are 2 columns. First column contains of text data like questions and second column contain answers like YES/NO in form of drop down with help of list in data validation.

What I want to achieve is that

1) if I select YES in second column then first column should change its color to Green

2) if I select NO in second column then first column should change its color to Red

enter image description here

is it possible?

1 Answers

0
Community On Best Solutions

1) For Yes and Green color condition

Selected Cells (For example B1:B11) that I wanted to fill with color > Selected Conditional formatting>Selected New rules> Selected "Use a formula to determine which cells to format" > Inserted formula as =$C2:$C11="Yes" in text field for "Format values where this formula is true" > selected "format" option> Selected "fill" option in Newly opened format cells window> Selected Green color and then hit "OK" twice and done.

2) For No and Red color condition (Followed same procedure as above) Selected Cells (For example B1:B11) that I wanted to fill with color > Selected Conditional formatting>Selected New rules> Selected "Use a formula to determine which cells to format" > Inserted formula as =$C2:$C11="No" in text field for "Format values where this formula is true" > selected "format" option> Selected "fill" option in Newly opened format cells window> Selected Red color and then hit "OK" twice and done.

That's all and it worked.

cell color formatting