Excel vba formatconditions range

Dim MyRange As Range
Set MyRange = ThisWorkbook.Worksheets(1).Range("A1:C10")
With MyRange    ' whole row into red when A value <> B value
	.Cells(1, 1).FormatConditions.Add Type:=xlExpression, Formula1:="=$A1<>$B1"
    .FormatConditions(1).Font.Color = vbRed
    .Cells.FormatConditions(1).ModifyAppliesToRange MyRange
End With

Similar codes

0 vote178 views1 answer
How to extract a file from an ISO:
VBA
1 vote192 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
1 vote177 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote175 views1 answer
Type excel.application is not defined vb
VBA
1 vote1.4K views1 answer
Vba Remove Case Sensitivity
VBA
0 vote189 views1 answer
Excel delete ever other vba
VBA
1 vote120 views1 answer
Ms access open form to new record
VBA
0 vote171 views1 answer
Excel vba show developer tab
VBA
0 vote179 views1 answer
Vba shape transparent
VBA
0 vote185 views1 answer
Average vba
VBA