VBA Code to Set Conditional Formatting in Excel

This code applies conditional formatting to the selected range based on a specific condition.

VBA Code:

Sub SetConditionalFormatting()
    Dim conditionRange As Range
    Dim condition As FormatCondition
    Set conditionRange = Selection
    Set condition = conditionRange.FormatConditions.Add(Type:=xlCellValue, Operator:=xlLess, Formula1:="0")
    With condition
        .Interior.Color = RGB(255, 0, 0)
        .Font.Color = RGB(255, 255, 255)
    End With
End Sub

Check All VBA Codes

Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group

Leave a Comment