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 vote218 views1 answer
Convert unix to date vba
VBA
0 vote214 views1 answer
Ribbon show/hide
VBA
25 votes540 views3 answers
String to date vb
VBA
0 vote213 views1 answer
Vba horizontalalignment
VBA
0 vote266 views1 answer
Vba excel do not recalculate before save
VBA
0 vote203 views1 answer
Excel vba join variant array
VBA
0 vote195 views1 answer
Vbnet get file name from path
VBA
1 vote225 views1 answer
Extract the second word in a text in excel
VBA
0 vote217 views1 answer
Vba format currency
VBA
0 vote199 views1 answer
Excel VBA web scraping
VBA