I have a workbook with different worksheet. I want to come up with a macro that highlights and bold the rows that has 'Terminate' or 'Term' in Column C and don't have N/A or have Blank in Column J. Should apply to all worksheet. Any help will be appreciated.
Quick Google got me but I also need help with additional logic.
.FormatConditions.Add Type:=xlExpression, Formula1:= _
.PatternColorIndex = xlAutomatic
.Color = 7405514
.TintAndShade = 0
StopIfTrue = False