Hello all.
Trying to compare values between cells in row 1 with offset cells in row 3 and get a 'Compile Error: Expected expression' on the colored line. I tried various combinations of () with various errors. How should this be written? Thanks.
Dim All_Data As Range
Dim Response As Range
Dim MyCell As Range, cellOffset As Range
Dim myRange As Range
Dim rng As Range
Set All_Data = Range("D1:F1")
Set cellOffset = All_Data.Offset(2, )
For Each MyCell In All_Data
If MyCell.Value < cellOffset.Value Then
'If MyCell.Value < 10 Then
MyCell.Interior.ColorIndex = 3 'RED
Bookmarks