If you set your formula as =$E:$E=“Yes”, then you will return nothing because the entire column E does not equate to “Yes”.
Instead, in only the first cell of which you would like to apply the conditional formatting (i.e. cell F1), set the conditional format formula to =E1=“Yes”. Then in the “applies to” section, select F:F. This will allow the conditional format to search in each adjacent cell for the text “Yes”.
For example, if cell E1 holds the value “Yes”, then cell F1 will be formatted grey. If the cell E2 holds the value “No”, then cell F2 will not be formatted grey.
I hope this helps! PReagan
*This post was sent via mobile so please excuse any typos