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 vote230 views1 answer
Excel vba hide columns
VBA
0 vote240 views1 answer
Excel vba first working day month
VBA
0 vote218 views1 answer
Vbnet dynamically change excel sheet name
VBA
0 vote236 views1 answer
Excel vba unmerge sheet
VBA
1 vote239 views2 answers
Vba string length
VBA
0 vote212 views1 answer
Excel protect cells with formulas
VBA
0 vote226 views1 answer
Excel vba range contains
VBA
1 vote218 views1 answer
Excel format cell as kilowatts
VBA
3 votes302 views1 answer
Excel vba make long from two shorts
VBA
0 vote280 views2 answers
Excel vba store array and write to sheet
VBA