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 vote180 views2 answers
Excel vba store array and write to sheet
VBA
22 votes254 views1 answer
Xlvba check for folder
VBA
0 vote141 views1 answer
Return na vba
VBA
0 vote140 views1 answer
.net crash app
VBA
0 vote139 views1 answer
Search combobox items vb.net
VBA
0 vote161 views1 answer
Amd64 vs arm64 linux
VBA
0 vote139 views1 answer
Dynamically change drop down list visual basic
VBA
5 votes146 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote129 views1 answer
Excel vba range contains
VBA
0 vote125 views1 answer
How to extract a file from an ISO:
VBA