Hi,
I am trying to update a cell (LR, 3) with Accept or Reject based on the colors from cell range (LR, 4) to (LR, 8). I am having trouble specifically this line, If Rng.Interior.ColorIndex = 3 Then.
What I would like to have happen is that is any of the cells are shaded red from being...