Forum Discussion
Solved
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.
=B2="no"You can apply this rule for conditional formatting.
=$A$2:$A$20This is the range the format applies to in the example.
=B2="no"You can apply this rule for conditional formatting.
=$A$2:$A$20This is the range the format applies to in the example.
- Thank you!!
