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 vote315 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote273 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote284 views1 answer
Telephon call in vba
VBA
0 vote248 views1 answer
How to sort datagridview in vb.net
VBA
5 votes330 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote297 views1 answer
Vbnet add axis labels to chart
VBA
0 vote313 views3 answers
Write to text file vb.net
VBA
0 vote286 views1 answer
Internet explorer reference vba
VBA
0 vote295 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote273 views1 answer
Excel vba disable alerts
VBA