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 vote319 views1 answer
Dynamically change drop down list visual basic
VBA
1 vote327 views1 answer
Excel vba make cell visible
VBA
4 votes404 views1 answer
VBA Deep Clone Dictionary
VBA
0 vote334 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote344 views1 answer
Vba range clear formatting
VBA
0 vote360 views2 answers
S yyyy-MM-dd em vb net
VBA
1 vote306 views1 answer
Vba listindex select multiple items vba
VBA
0 vote333 views1 answer
Vbnet line chart showing extra space
VBA
0 vote492 views1 answer
Amd64 vs arm64 linux
VBA
0 vote335 views1 answer
Vbnet check if string is only numbers
VBA