SOLVED

# conditional formatting a cell based on the text of another cell

Copper Contributor

# conditional formatting a cell based on the text of another cell

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

# Re: conditional formatting a cell based on the text of another cell

``=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.

# Re: conditional formatting a cell based on the text of another cell

Thank you!!
1 best response

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

# Re: conditional formatting a cell based on the text of another cell

``=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.