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 vote313 views1 answer
Vba count all row
VBA
0 vote251 views1 answer
Excel vba concatenate range
VBA
5 votes793 views1 answer
Vlookup vba
VBA
0 vote297 views1 answer
Vba open report
VBA
1 vote320 views2 answers
Vba find last row in range for certain criteria
VBA
1 vote289 views1 answer
Excel vba saveas force overwrite
VBA
8 votes316 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote299 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
-1 vote313 views1 answer
Code for reading letters only in vb 6
VBA
0 vote303 views1 answer
Menus act like radio buttons vb.net
VBA