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 vote155 views1 answer
Filesystemobject vba reference
VBA
31 votes154 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
8 votes194 views1 answer
Excel vba make word from bytes
VBA
0 vote120 views1 answer
Prive sub enter clicked vb
VBA
2 votes127 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote126 views1 answer
Vba clear collection
VBA
3 votes135 views1 answer
Excel insert blank row for value change in column
VBA
0 vote130 views1 answer
Vba table header name
VBA
0 vote136 views2 answers
Checking and changing system volume vb.net
VBA
0 vote121 views1 answer
Default host vbox address
VBA