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 vote189 views1 answer
Vba add spaces
VBA
0 vote183 views1 answer
Vba is integer
VBA
0 vote170 views1 answer
Check if program is running vbnet
VBA
0 vote175 views1 answer
Vba word open document read only
VBA
0 vote185 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote209 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote180 views1 answer
Delete all controls in an area vb
VBA
0 vote207 views1 answer
Winforms dark title bar
VBA
8 votes203 views1 answer
Vba make integer
VBA
13 votes240 views2 answers
Vba write text file
VBA