Excel 2003 - Change Row Colour with VBA
Solved/Closed
Related:
- Excel 2003 - Change Row Colour with VBA
- Crimping colour code - Guide
- Number to words in excel formula without vba - Guide
- How to change date format in excel - Guide
- Vba case like - Guide
- How to change author in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 22, 2010 at 02:03 PM
Jul 22, 2010 at 02:03 PM
Private Sub Worksheet_Change(ByVal Target As Range) Set MyPlage = Range("B13:I50") For Each Cell In MyPlage Select Case Cell.Value Case Is = "Withdrawn" Cell.EntireRow.Interior.ColorIndex = 7 Case Is = "Postponed" Cell.EntireRow.Interior.ColorIndex = 8 Case Is = "Terms Agreed" Cell.EntireRow.Interior.ColorIndex = 4 Case Is = "Papers Rec" Cell.EntireRow.Interior.ColorIndex = 3 Case Else Cell.EntireRow.Interior.ColorIndex = xlNone End Select Next End Sub
Jul 25, 2010 at 01:17 PM
Thanks for a swift response!