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 highlightChoose 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