Brian from Maui
MrExcel MVP
- Joined
- Feb 16, 2002
- Messages
- 8,459
I am in need of some (lots) help. Presently to highlight the active row, I use CF and
=CELL("row")=ROW(), then using
What I want to combine with this is,
IF S3 equals "Active" color A3:T3 green
IF S3 equals "Closed" color A3:T3 red
IF S3 equals "Prospect" font color red in A3:T3
the range of the sheet is from A3:T300
TIA
=CELL("row")=ROW(), then using
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Application.ScreenUpdating = True
End Sub
What I want to combine with this is,
IF S3 equals "Active" color A3:T3 green
IF S3 equals "Closed" color A3:T3 red
IF S3 equals "Prospect" font color red in A3:T3
the range of the sheet is from A3:T300
TIA