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 votes237 views1 answer
Excel vba make long from two shorts
VBA
1 vote196 views2 answers
Excel vba password protect
VBA
20 votes276 views1 answer
Excel vba recursive example factorial function
VBA
0 vote213 views1 answer
Add text to combobox drop down vb
VBA
0 vote215 views1 answer
Excel vba protect scenarios
VBA
0 vote226 views1 answer
Vba horizontalalignment
VBA
3 votes208 views1 answer
Excel vba get the workbook full file name with path
VBA
27 votes279 views2 answers
Vba check if file exists
VBA
0 vote198 views1 answer
Vba option button selected
VBA
0 vote226 views1 answer
.net crash app
VBA