macro to fill color in blank cells based on filtering values in other columns

E

excelhelpseeker

New member
Joined
Jan 7, 2015
Messages
29
Reaction score
0
Points
0
Hi Champs,

I have 3 column
Col A - code
Col B - Status
Col C - Term

i need to filter col A (only 1,2,7) and col C (only T and 36) and Col B (only blanks)

the col B with blank cells has to be highlighted. Please refer the sample file with output attached

Please helpView attachment sample.xlsx
 
Code: 
Sub blah()
With Range("A1")
  .AutoFilter Field:=1, Criteria1:=Array("1", "2", "7"), Operator:=xlFilterValues
  .AutoFilter Field:=3, Criteria1:="=36", Operator:=xlOr, Criteria2:="=T"
  .AutoFilter Field:=2, Criteria1:="="
  With ActiveSheet.AutoFilter.Range
    .Offset(1, 1).Resize(.Rows.Count - 1, 1).Interior.Color = 65535
  End With
  .AutoFilter
End With
End Sub
 
You must log in or register to reply here.
Back
Top