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 vote212 views1 answer
If inputbox cancel vba
VBA
0 vote209 views1 answer
Loop through all text boxes in a form vb
VBA
8 votes223 views1 answer
Excel vba make integer
VBA
4 votes208 views2 answers
Vba create folder if not exist
VBA
15 votes491 views2 answers
Xl vba dynamic string array
VBA
4 votes195 views1 answer
Excel vba check cell not empty
VBA
5 votes237 views1 answer
Vba low word from Long Integer
VBA
0 vote194 views1 answer
Do until vb.net
VBA
0 vote227 views1 answer
Delete all controls in an area vb
VBA
5 votes217 views1 answer
Excel-vba get integer high byte
VBA