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 vote210 views1 answer
Vba login website
VBA
0 vote196 views1 answer
Vba code to select image in sheet
VBA
3 votes239 views1 answer
Vba continue for each loop
VBA
0 vote190 views1 answer
Vba get text file content
VBA
0 vote200 views1 answer
Type excel.application is not defined vb
VBA
0 vote195 views1 answer
VBA Loop to range
VBA
0 vote202 views1 answer
Loop through each cell in dgv vbnet
VBA
0 vote196 views1 answer
Vbs write file
VBA
8 votes209 views1 answer
Run command pormpt in background windows
VBA
0 vote208 views1 answer
Reference to a non-shared member requires an object reference
VBA