Thanks for the cleanup!
OK… I admit… I know enough VB to make me REALLY dangerous.
I think what you were telling me is to move the above code from the color page (Color tab) to the worksheet where the data is changing (Summary tab), correct? I did that and now I get a “Run-Time error ‘1004’...
I've read past threads and you guys have been a big help. From a previous thread I have added the following code to format the cell for a specific temperature.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim oCell As Range
For Each oCell In Range("A2:s17")
Select Case...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.