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

5 votes189 views1 answer
Excel vba get user selected range
VBA
15 votes247 views2 answers
Xl vba dynamic string array
VBA
6 votes185 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote192 views1 answer
Rotate image by any angle vb.net
VBA
0 vote252 views1 answer
Amd64 vs arm64 linux
VBA
2 votes183 views1 answer
Vba round number
VBA
0 vote201 views1 answer
Vba sheet hide unhide
VBA
0 vote188 views1 answer
Average vba
VBA
0 vote187 views2 answers
Get excel file from email attachment in vba
VBA
1 vote174 views1 answer
Excel vba first and last row and column in range
VBA