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 vote332 views1 answer
Vba file chooser
VBA
0 vote324 views1 answer
Change whcih control a user has selected vb
VBA
3 votes330 views2 answers
Excel "vba" match last value
VBA
3 votes358 views1 answer
Vba double quote
VBA
0 vote330 views1 answer
Excel run macro every 5 minutes
VBA
3 votes363 views1 answer
Vba post request json
VBA
0 vote334 views1 answer
Vba leading zeros in string
VBA
0 vote335 views1 answer
Vba timestamp -- milliseconds
VBA
-1 vote318 views2 answers
How close excel through visual basic
VBA
1 vote364 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA