This OP has presented an issue that is above my ability to solve. VBA is the means as it involves .interior.colorindex over four different ranges that need to be compiled.

https://www.excelforum.com/excel-pro...ls-pt-2-a.html