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