Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by p8md
-
Excel conditional fomat using VB help
Thanks! That works great!- p8md
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel conditional fomat using VB help
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’...- p8md
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel conditional fomat using VB help
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...- p8md
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
