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

1 vote130 views2 answers
Vba remove first 2 characters from string
VBA
0 vote156 views1 answer
Thread sleep vb
VBA
6 votes162 views1 answer
Excel vba isalpha
VBA
18 votes279 views3 answers
Excel-vba make integer
VBA
1 vote137 views1 answer
Vba delete file
VBA
1 vote155 views1 answer
Sort using vba
VBA
0 vote134 views1 answer
Excel vba disable screen update
VBA
0 vote133 views1 answer
Excel vba populate array with cell values
VBA
0 vote138 views2 answers
Excel vba close without saving
VBA
0 vote149 views2 answers
Vb.net include quotes in string
VBA