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 votes379 views1 answer
Vba http request json
VBA
0 vote370 views1 answer
Convert number to minutes in vba
VBA
0 vote349 views1 answer
Excel vba show developer tab
VBA
0 vote398 views1 answer
Excel vba DisplayAlerts
VBA
-1 vote380 views1 answer
Vba code to add new column in table
VBA
-1 vote401 views1 answer
How save excel through visual basic
VBA
0 vote344 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
0 vote375 views1 answer
Send text to clipboard vb.net
VBA
0 vote388 views1 answer
Vba clear collection
VBA
0 vote369 views1 answer
Vbnet add axis labels to chart
VBA