****demo.xlsm file link
https://drive.google.com/open?id=0B1u8QGSQIxdoeXRvRHd2THVaenM
following code is working only for 28 Ranges which is 15849 cells (highlight in red color) but not running with all ranges that past below in brown color
Find same value and Changing a cell & tex color...