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 vote247 views1 answer
Excel vba delete folder
VBA
0 vote266 views1 answer
Vba nested dictionary
VBA
0 vote247 views1 answer
Regex numeric digits
VBA
4 votes290 views1 answer
VBA Deep Clone Dictionary
VBA
0 vote245 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote238 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote244 views1 answer
Vbnet check if string is only numbers
VBA
1 vote235 views1 answer
Highlight selected cell in excel vba
VBA
0 vote233 views1 answer
Returns an array from function vba
VBA
0 vote265 views2 answers
VB
VBA