View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default format row based on non-blank or blank cell

Put this code in the worksheet you wish to act on, when the worksheet
changes the current row is tested

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 5 Or Target.Column = 14 Then
If Val(Cells(Target.Row, 5)) = 0 And Trim(Cells(Target.Row, 14)) = ""
Then
Rows(Target.Row).Font.ColorIndex = 15
Else
Rows(Target.Row).Font.ColorIndex = 0
End If
End If
End Sub

--
Cheers
Nigel



"mhoffmeier" wrote in message
oups.com...
Hello,
I use excel for construction estimates. It would be a nice if a line
item would be black if either the quantity was filled in, or the notes
field was filled out explaining why it was not. I'd like the other
line items to be grey, but not deleted. what might a program look like
that made a row grey if either column e or n were blank?
Thanks