yogi_Conditionally Format Column A If Neighboring Column B Houses Yes or ✔

Google Spreadsheet   Post  #2346

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-18-2018

question by: ship

https://productforums.google.com/forum/#!topic/docs/T6m4gJ__M-8;context-place=forum/docs

Is it possible to create Conditional Formatting that uses a neighbouring cell's value?
Hello 

Is there any way to create conditional formatting that depends on a cell OTHER than the one being formatted?

i.e. I want to change the formatting of a cell if the next door cell contains the word "Yes"  (or the  ✔ character).

Thanx

J