Forum Discussion
Jasmine08
Jul 15, 2024Copper Contributor
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 states "YES".
I am running a MacBook with Excel Version 16.86 (24060916).
Select entire range, let say A2:E1000 and in the rule use formula =$E2="Yes"