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

3 votes167 views1 answer
Vba folderexists
VBA
0 vote171 views1 answer
Vba sheet visible
VBA
0 vote183 views4 answers
Jwt token vb.net validation
VBA
8 votes328 views1 answer
Vba make a short integer from two bytes
VBA
0 vote229 views2 answers
Excel vba store array and write to sheet
VBA
5 votes191 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote212 views1 answer
Vba foreach 2d array
VBA
0 vote220 views1 answer
Vba userform textbox wrap text
VBA
0 vote174 views1 answer
Vba file chooser
VBA
0 vote194 views1 answer
Vba dictionary length
VBA