SOLVED

conditional formatting a cell based on the text of another cell

Copper Contributor

Is there a way to make a cell highlight based on yes/no text of another cell? 

 

The situation: A= name of individual, B= contacted (yes/no)

Can A be conditionally formatted to be filled yellow if the individual was not yet contacted (cell B=no)? I am having a hard time figuring out the formula for this. 

2 Replies
best response confirmed by k987456 (Copper Contributor)
Solution

@k987456 

=B2="no"

You can apply this rule for conditional formatting.

=$A$2:$A$20

This is the range the format applies to in the example.

conditional format.png

1 best response

Accepted Solutions
best response confirmed by k987456 (Copper Contributor)
Solution

@k987456 

=B2="no"

You can apply this rule for conditional formatting.

=$A$2:$A$20

This is the range the format applies to in the example.

conditional format.png

View solution in original post