Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Apr-01-2014
post by Casey Cassel (https://productforums.google.com/forum/#!mydiscussions/docs/WpuYBjrhVJ0)
Spreadsheets Script Cell Background Color
I'm creating a spreadsheet for my workplace that is a pretty basic work log. Users will fill out the log with different information on each order. We are wanting a way of "duplicate orders" being highlighted in an effort to eliminate two people doing the same order simultaneously. The first column of our spreadsheet is the order number that we are wanting to highlight as RED if it's a duplicate number. The following code does that.. but it also changed non-duplicates to WHITE.