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 vote236 views1 answer
Vba html document reference
VBA
0 vote223 views1 answer
Vba exit while
VBA
0 vote232 views2 answers
Do until loop vba
VBA
0 vote237 views1 answer
Excel vba remove formatting from cell
VBA
0 vote262 views1 answer
Tester si une case est vide vba
VBA
0 vote221 views1 answer
Excel vba extract year
VBA
0 vote255 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote248 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote236 views1 answer
Vbnet add axis labels to chart
VBA
5 votes182 views1 answer
Vba array worksheet.index
VBA