Sub 题目()
Dim rg As Range
Set rg = Sheets("sheet3").Columns("b:d").SpecialCells(xlCellTypeConstants)
Application.Intersect(Sheet3.Columns(1), rg.EntireRow).Value = 1
Application.Intersect(Sheet3.Columns(1), rg.EntireRow).Interior.Color = vbYellow
End Sub