Today I want to share with you about experiences of Excel! The topic today is highlight entire row if cell contains special text
We want to highlight entire rows with GREEN COLOR if cell contains “yes” text, same as the below pictures
Step 1:
Choose all data with highlight
Choose Home -> Conditional Format -> New Rule -> Use a formula to determine which cells to format
Step 2:
type conditions by choose cell contains special text: my yes, no text on D1 columns (=$D$1 = “yes”)
Step 3: Important Step
Remember remove $ before 1, If you don’t remove it, you will get the problem is entire rows will be fill color
$D1 = “yes”
Press Enter | OK to see the results
Any feedback, leave your comment below this posts, we can discuss about it
Thanks 🙂
Zidane