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

8 votes253 views1 answer
Vba make integer
VBA
0 vote233 views1 answer
Excel vba copy range with filter
VBA
0 vote230 views1 answer
Excel vba clear filter
VBA
4 votes230 views2 answers
Excel vba last column with data
VBA
0 vote223 views1 answer
Vlookup columns not next to each other
VBA
0 vote212 views1 answer
Find days in month vba
VBA
4 votes203 views1 answer
Excel vba how to reset usedrange
VBA
0 vote211 views1 answer
Vb.net visible property dgv collumn not working
VBA
0 vote231 views1 answer
Vba first cell in range
VBA
13 votes288 views2 answers
Vba write text file
VBA