Hi matts:
Welcome to the Board!
You can use the following conditional formatting for the rows of interest ...
Formula Is =cell("row")=row() ... Pattern -- specify color of your choice, say 'Yellow'
This will highlite the entire row on either making an entry in any cell of that row, or using the DEL key, or using the F9 key
If you want to have the entire row highlighted simply on selection without having to make an entry in any cell, or using the DEL key, or the F9 key, you can use the following SUB to force CALC on any cell selection in the sheet:
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Calculate
End Sub
You want to check whether it is desirable for you to use the SUB for the automatic calculation feature.
Regards!
Yogi