yogi_Conditionally Format Cells In Cells N4 To S Where Order Number In Column D Exists In Column N

                Google Spreadsheet   Post  #1835

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-17-2014

post by Sean Christian:
(https://productforums.google.com/forum/#!mydiscussions/docs/qrl9wudvDIU)
Conditional Format for Dates - Need more than one Cell highlighted
Hi Yogi:

I've added more examples into the spreadsheet, as well as highlighted the cells that should automatically highlight according to the data that is placed in column D (Order # Claim). The common denominator between the two sides is the Order Number. Once an order number is placed into column D, it's corresponding partner should highlight, as well as the adjacent cells (N:S). Reminder: columns N:S contain dynamic data, so we may be looking at some form of array. I appreciate you taking the time to help!

Regards,

Sean

-----------------------------------------------------------------------------------------------------------------------------------------------