Thursday, January 18, 2018

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
Is it possible to create Conditional Formatting that uses a neighbouring cell's value?

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