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     www.energyefficientbuild.com.   Mar-20-2016

post by: Ryan PP:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!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