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

5 votes166 views1 answer
Excel vba how to unit test vba code
VBA
0 vote146 views1 answer
Send text to clipboard vb.net
VBA
-1 vote145 views1 answer
Vba code to add new column in table
VBA
15 votes269 views2 answers
Xl vba dynamic string array
VBA
0 vote152 views2 answers
Vba remove line breaks
VBA
0 vote161 views1 answer
Vba multiple optional arguments
VBA
0 vote150 views1 answer
Vba vbcrlf chr
VBA
0 vote130 views1 answer
Find days in month vba
VBA
3 votes161 views1 answer
Extract word in a text in excel
VBA
0 vote157 views1 answer
Excel vba set cell value to empty
VBA