Wednesday, January 14, 2015

yogi_Conditionallty Format Rows If Same Date (column B) And Name (column D) Occur More Than Two Times

             Google Spreadsheet   Post  #1882
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-14-2015
post by  TN Dispatch:
https://productforums.google.com/forum/#!mydiscussions/docs/O-qBgP_njDU
how to color a row of cells if a value occurs more then twice
I am looking for a script or formula that will color coat a row if a value occurs more then once on the same date. I have attatched the sheet for reference. If you notice column b has dates c has company names and d has names i would like if adam with tn transport has more then 2 entrys on the 6th then those rows are colored orange with blue text. 

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

No comments:

Post a Comment