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 vote335 views1 answer
Style percent not found vba
VBA
0 vote316 views1 answer
Vba html document reference
VBA
0 vote316 views1 answer
Write listbox to text file vb.net
VBA
0 vote305 views1 answer
Vba full date format
VBA
0 vote306 views1 answer
Vbscript check if string is empty
VBA
1 vote303 views1 answer
Excel date to unix timestamp
VBA
0 vote305 views1 answer
Vba DisplayGridlines
VBA
0 vote308 views1 answer
Vba collection key list
VBA
20 votes448 views1 answer
Excel vba recursive example factorial function
VBA
1 vote348 views1 answer
Vba login website
VBA