Sunday, March 20, 2016

yogi_Conditionally Format Columns A and B When Columns A and B In Corresponding Rows Are Not Blank

Google Spreadsheet   Post  #2054
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Mar-20-2016
post by: Ryan PP:!topic/docs/mIyA4WCQ8Jg;context-place=forum/docs
Conditional formatting for range based on data in another range
Hello, I am trying to set up a rule that will highlight cells in Sheet1 based on if that cell in sheet 2 has data in it

I want to apply it to a range B2:AF26

My rule is =indirect("Sheet2$B$2:$AF$26")<>"" but am receiving a formula error

My logic should go if Sheet2!B2 has data in it then highlight Sheet1!B2, if Sheet2!B3 has data in then highlight Sheet1!B3, and so on for the array B2:AF26
Is there a way I can do this with 1 rule?
following is solution to a bit more generalized problem