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).

excel

Excel on Mac

Formulas and Functions

office 365

SergeiBaklan
Jul 15, 2024
Jasmine08

Select entire range, let say A2:E1000 and in the rule use formula =$E2="Yes"

5 Replies

SergeiBaklan
Diamond Contributor
Jul 15, 2024
Jasmine08

Select entire range, let say A2:E1000 and in the rule use formula =$E2="Yes"
- Jasmine08
  Copper Contributor
  Sep 17, 2024
  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"?
  - SergeiBaklan
    Diamond Contributor
    Sep 18, 2024
    Jasmine08
    
    It could be
- Jasmine08
  Copper Contributor
  Jul 15, 2024
  Thank you SO much!
  - SergeiBaklan
    Diamond Contributor
    Jul 15, 2024
    Jasmine08 , you are welcome

Forum Discussion

Highlight an entire row based on data in one cell

5 Replies

Resources