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 vote160 views1 answer
Add Formula to Shape Text in VBA
VBA
0 vote171 views1 answer
Excel delete ever other vba
VBA
1 vote180 views1 answer
Vba loop through files in folder
VBA
0 vote169 views1 answer
Excel vba calculate
VBA
1 vote156 views1 answer
Excel vba saveas force overwrite
VBA
0 vote196 views1 answer
Vb ternary
VBA
3 votes164 views1 answer
Excel vba make long from two shorts
VBA
3 votes167 views1 answer
Vba make long from two shorts
VBA
1 vote161 views2 answers
Vba string to date
VBA
0 vote166 views1 answer
Loop through each cell in dgv vbnet
VBA