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 vote129 views1 answer
Text to speech vb.net
VBA
0 vote140 views1 answer
How to carry text to the next line in a label in vb.net
VBA
2 votes128 views1 answer
Vba array contains
VBA
0 vote142 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
0 vote94 views10 answers
Vba excel create event log
VBA
0 vote137 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote148 views1 answer
Excel vba StartUpPosition
VBA
-1 vote136 views1 answer
VBA check if a cell contains a letter or string
VBA
5 votes151 views1 answer
Excel vba low word from Long Integer
VBA
1 vote146 views1 answer
Find and replace textbox
VBA