I am currently using a great sample file written by Debra Dalgleish on her website Excel Tips and Techniques. However, there is one thing I would like for the file to do which I have unsuccefuly been able to do. I would like the conditional format in the 'MAIN' sheet to carry over to all the other sheet based on the column A; City Name. My conditional format shows-up in the Main sheet but...


