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 vote164 views1 answer
Returns an array from function vba
VBA
0 vote170 views1 answer
.net crash app
VBA
0 vote175 views1 answer
Excel vba DisplayAlerts
VBA
0 vote152 views1 answer
Change whcih control a user has selected vb
VBA
1 vote160 views1 answer
Vba date to unix timestamp
VBA
2 votes153 views1 answer
Vba uppercase first letter of each word
VBA
0 vote207 views1 answer
Visual basic cmd
VBA
1 vote1.1K views1 answer
Vba Remove Case Sensitivity
VBA
0 vote172 views1 answer
VBA is form loaded
VBA
0 vote176 views1 answer
Vba clear collection
VBA