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 vote143 views1 answer
Vba declare api 64 bit 32 bit
VBA
1 vote149 views1 answer
Excel vba get column number from column name
VBA
3 votes146 views1 answer
Extract the nth word from a text string
VBA
6 votes158 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote134 views1 answer
Vba argument is set
VBA
0 vote157 views1 answer
Windows Forms dark title bar
VBA
0 vote158 views1 answer
Open file dialog in vb.net
VBA
1 vote160 views2 answers
Excel vba password protect
VBA
7 votes170 views1 answer
Excerl vba array to range
VBA
1 vote143 views1 answer
What does vbs stand for
VBA