Changing color of a row when typed in...Closed

Question

Hello, 

I'm making an excel spreadsheet. What I'm wanting to do is have a row turn red if I type something in the first cell.

For example: If I type something in A2, I want cells A2:R2 to turn red.

I've tried to search through some other questions, but cannot find my way through this. I don't know if I need to do an IF formula or Conditional Formatting. Please help!

Configuration: Windows 7 / Firefox 14.0.1

venkat1926 · Answer

you need an EVENT HANDLER

RIGHT CLICK THE TAB OF THE PARTICULAR SHEET
CLICK VIEW CODE

in the window that opens copy this event code

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
Application.EnableEvents = False
Range(Target, Cells(Target.Row, "R")).Interior.ColorIndex = 3
Application.EnableEvents = True
End Sub

save the file

NOW GO TO THE SHEET SOMETHING IN ANY CELL IN COLUMN A

bwhite06 · Answer

That worked great! The row turns red once I type in it. But if I delete what I typed to turn the row red, the row remains red.

Is there any way to make it "un-highlight" the row once something is deleted from the cells in column A?

Changing color of a row when typed in...

2 responses

Similar discussions

Subscribe To Our Newsletter!