Forum Discussion
Solved
Highlight an entire row based on data in one cell
Hello all, I have searched and tried many of the solutions in the previous posts, but I am having difficulty with the rule. I'm attempting to highlight an entire row if a cell in the E column sta...
Select entire range, let say A2:E1000 and in the rule use formula =$E2="Yes"
Thank you! How would I make it so that the cells in A only highlight if both the cells in E and F say "Yes"?