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 vote254 views1 answer
If statement vdhl
VBA
0 vote217 views1 answer
Vba dropdown event
VBA
4 votes229 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote209 views2 answers
Excel vba copy paste after last row
VBA
0 vote263 views1 answer
Wpf dark title bar
VBA
0 vote234 views1 answer
Weekday vba
VBA
0 vote216 views1 answer
Vb get ip address
VBA
0 vote220 views1 answer
Vba open report
VBA
-1 vote229 views2 answers
Excel vba delete empty rows
VBA
-1 vote253 views1 answer
How to correct a number to 2 decimal places in vba
VBA