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 vote354 views1 answer
VBA Loop through recordset
VBA
0 vote355 views1 answer
Vba timestamp -- milliseconds
VBA
8 votes392 views1 answer
Excel vba determine number of elements in a 1D array
VBA
0 vote343 views1 answer
Vbnet check if number is even or odd
VBA
0 vote344 views1 answer
Set column width of datagridview vb.net
VBA
1 vote351 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote338 views1 answer
Excel vba disable mouse click
VBA
0 vote355 views1 answer
Vbscript Trim
VBA
0 vote344 views1 answer
Excel vba disable keyboard input
VBA
0 vote358 views1 answer
Vba collection key list
VBA