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 vote326 views1 answer
Vba round to 2 decimals
VBA
0 vote310 views1 answer
How to extract a file from an ISO:
VBA
0 vote342 views1 answer
Make your computer talk vbscript
VBA
1 vote323 views2 answers
Vba function return array
VBA
4 votes314 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
0 vote322 views1 answer
Excel protect cells with formulas
VBA
1 vote314 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote317 views1 answer
Vbnet check if sting contians symbols
VBA
0 vote307 views1 answer
Vbs write file
VBA
2 votes314 views1 answer
Excel vba check if string entirely numeric
VBA