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 vote240 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote250 views1 answer
Vba array of integers
VBA
4 votes228 views1 answer
Excel vba check cell not empty
VBA
0 vote225 views1 answer
Vbnet dynamically change excel sheet name
VBA
3 votes230 views1 answer
Excel vba last row in range
VBA
1 vote246 views1 answer
If inputbox cancel vba
VBA
0 vote241 views1 answer
Excel run macro every 5 minutes
VBA
0 vote238 views1 answer
String contins in vba
VBA
25 votes529 views2 answers
Excel vba folder exist
VBA
0 vote258 views1 answer
Excel vba move down to next visible cell
VBA