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

1 vote268 views1 answer
Vba optional
VBA
1 vote224 views1 answer
Vba exit do while
VBA
0 vote281 views1 answer
Excel vba disable screen update
VBA
5 votes278 views1 answer
Excel formula how to create strings containing double quotes
VBA
0 vote279 views1 answer
Excel vba join variant array
VBA
0 vote285 views1 answer
Vba string
VBA
0 vote280 views1 answer
Do while not vb.net
VBA
0 vote244 views1 answer
Excel vba arrondir
VBA
5 votes278 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote265 views1 answer
Set column width of datagridview vb.net
VBA