Conditional Formatting Macro

[reza_doang]

Hi -

Please help, i have many sheets, in each sheet for Columns B to M, if there is values below 98 will highlight with yellow.
kindly help with macro, so i don't need to manual in each sheet.

Thanks in advance

 

[footoo]

Dim ws As Worksheet
For Each ws In Worksheets
    With ws.[B:M]
        .FormatConditions.Add Type:=xlExpression, Formula1:="=AND(B1>0,B1<98)"
        .FormatConditions(1).Interior.ColorIndex = 6
    End With
Next