yogi_Conditional Formatting For Items Where Every Material Listed Has Been Priced And Used For Open Ended List of Materials

                    Google Spreadsheet   Post  #1774
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-26-2014
post by  robodawg42:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/TwxMuRFJ2Yw)
How do I use conditional formatting governed by multiple cells?

following is a case ...
where I have highlited cells in column D where all listed materials have been priced and used in an item