firefytr said:
Does it all base itself off of row 26? Give 2-4 good examples of a working color combination. Complete with cell values (case sensitive), and don't forget to mention which cell being updated will trigger this. Point out which cells will be looking at what to change, etc.
No, it doesn't all base off of CellC26, but that is the first cell that the city name will change, meaning that cell could be one of thirty different cities.
The cells that will change city names are:
City Name Change will effect color in ell C26,which will effect color in C29 and effect C30 thru C33 Then
City Name Change will effect color in ell C37,which will effect color in C40 and effect C41 thru C43 Then
City Name Change will effect color in ell C48,which will effect color in C51 and effect C52 thru C54 Then
City Name Change will effect color in ell C59,which will effect color in C62 and effect C63 thru C65 Then
City Name Change will effect color in ell C70,which will effect color in C73 and effect C74 thru C76 Then
City Name Change will effect color in ell C81,which will effect color in C84 and effect C85 thru C87 Then
City Name Change will effect color in ell C92,which will effect color in C95 and effect C96 thru C98 Then
City Name Change will effect color in ell C103,which will effect color in C106 and effect C107 thru C109 Then
City Name Change will effect color in ell C114,which will effect color in C117 and effect C118 thru C120 Then
City Name Change will effect color in ell C125,which will effect color in C128 and effect C129 thru C131 Then
City Name Change will effect color in ell C136,which will effect color in C139 and effect C140 thru C142 Then
City Name Change will effect color in ell C147,which will effect color in C150 and effect C151 thru C153 Then
City Name Change will effect color in ell C158,which will effect color in C161 and effect C162 thru C164 Then
City Name Change will effect color in ell C169,which will effect color in C172 and effect C173 thru C175 Then
City Name Change will effect color in ell C180,which will effect color in C183 and effect C184 thru C186 Then
City Name Change will effect color in ell C191,which will effect color in C194 and effect C195 thru C197 Then
City Name Change will effect color in ell H26,which will effect color in H29 and effect H30 thru H33 Then
City Name Change will effect color in ell H37,which will effect color in H40 and effect H41 thru H43 Then
City Name Change will effect color in ell H48,which will effect color in H51 and effect H52 thru H54 Then
City Name Change will effect color in ell H59,which will effect color in H62 and effect H63 thru H65 Then
City Name Change will effect color in ell H70,which will effect color in H73 and effect H74 thru H76 Then
City Name Change will effect color in ell H81,which will effect color in H84 and effect H85 thru H87 Then
City Name Change will effect color in ell H92,which will effect color in H95 and effect H96 thru H98 Then
City Name Change will effect color in ell H103,which will effect color in H106 and effect H107 thru H109 Then
City Name Change will effect color in ell H114,which will effect color in H117 and effect H118 thru H120 Then
City Name Change will effect color in ell H125,which will effect color in H128 and effect H129 thru H131 Then
City Name Change will effect color in ell H136,which will effect color in H139 and effect H140 thru H142 Then
City Name Change will effect color in ell H147,which will effect color in H150 and effect H151 thru H153 Then
City Name Change will effect color in ell H158,which will effect color in H161 and effect H162 thru H164 Then
City Name Change will effect color in ell H169,which will effect color in H172 and effect H173 thru H175 Then
City Name Change will effect color in ell H180,which will effect color in H183 and effect H184 thru H186 Then
City Name Change will effect color in ell H191,which will effect color in H194 and effect H195 thru H197 Then
and if there is no city name in the cell, then to skip it and look at the next one. Once cycle ends return to Range("f4").Select.