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

4 votes217 views1 answer
Excel vba check cell not empty
VBA
1 vote233 views1 answer
Vba login website
VBA
0 vote234 views1 answer
Excel last used row
VBA
0 vote177 views1 answer
Vbide vbproject reference
VBA
0 vote255 views1 answer
Get month number from month name vbnet
VBA
13 votes500 views2 answers
Vba write text file
VBA
0 vote227 views1 answer
Delete rows in excel vba code
VBA
0 vote228 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote171 views1 answer
How to sort datagridview in vb.net
VBA
0 vote216 views1 answer
Vb check if row has column
VBA