With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, November 17, 2014
yogi_Conditionally Format Cells In Cells N4 To S Where Order Number In Column D Exists In Column N
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!