Aug 21 2019 08:22 AM - edited Aug 21 2019 11:12 AM
I am not sure what I am doing incorrectly when trying to do conditional formatting:
Thank you for your time!
A
Aug 21 2019 11:41 AM
Hello @analis_yeg,
Assuming your data starts at cell E1:
Set your formula to =E1="Yes" and apply it to $F:$F.
This should fix your issue.
Aug 21 2019 01:35 PM
Here is what my formula looks like when I go under conditional formatting:
=$E:$E="Yes"
format grey
applies to: =$F:$F
When I apply this, nothing happens. Same if I just choose 2 cells as opposed to 2 columns...
Aug 21 2019 02:11 PM
I have tried with full columns as well as individual cells. My formula looks like this: =$E:$E=”Yes”
format grey
applies to =$F:$F
I then go to my document and choose Yes from the pull down menu and it does not change any cells.
Please advise