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 votes137 views1 answer
Vba double quote
VBA
0 vote110 views1 answer
Add Formula to Shape Text in VBA
VBA
1 vote140 views1 answer
How to remove zeros in excel
VBA
2 votes116 views1 answer
Vba uppercase first letter of each word
VBA
0 vote129 views1 answer
How to mount floppy disks in vb.net
VBA
0 vote116 views1 answer
Vba check 32 or 64 bit
VBA
0 vote134 views1 answer
Arq linux
VBA
0 vote130 views1 answer
Excel vba unlock sheet without password
VBA
0 vote139 views1 answer
Date as number vb
VBA
32 votes250 views2 answers
Excel vba column letter
VBA