ColorIndex works but RGB doesn't

Hi. I wrote a code that goes through the rows of a every sheet in a workbook and finds the ones that have one of two colors, then copies that needed data from that row and pastes it into another tab that was created earlier in the macro. Essentially, it skips a row unless it's highlighted yellow (ColorIndex = 6) or a pinkish color, RGB(230, 184, 183). My macro works for the ColorIndex, but not for the RGB, no matter what the ColorIndex or RGB values are (I've tried different ones to be sure). I've even tried not doing it as an 'Or' and just doing the ColorIndex (which works) or just the RGB (which doesn't work). Am I not using the RGB correctly? See the relevant code below:

For j = 1 To sheetnum
For i = 5 To 100
Sheets(j).Activate
If Cells(i, 5).Interior.ColorIndex = 6 Or Cells(i, 5).Interior.Color = RGB(230, 184, 183) Then 'Looks for yellow and red cells
Cells(i, 4).Select
Range(Cells(i, 4), Cells(i, 11)).Copy
Sheets("Sourcing").Activate 'Switches to the Sourcing tab
ActiveSheet.Paste Destination:=Worksheets("Sourcing").Range(Cells(n, 2), Cells(n, 11))
'QT.Activate 'Goes back to QT sheet
n = n + 1 'next row
order = order + 1 'next order number
End If
Next i
Next j

Hi & welcome to the board.
Select one of the cells that have the pink fill & run this

Please Login or Register  to view this content.

What number does the msgbox show?

The number in the msgbox is 10079487

RGB(230,184,183) should be 12040422

You're right. I think I know what is happening but not exactly why. 1240422 matches the cell background color for most of the cells. It's the sheet's default cell color. However, there is a conditional formatting that changes some of those cells to the RGB(230,184,183). When I change my code to:

Cells(i, 5).Interior.Color = 1240422

it finds nothing, just like the RGB. But when I change it to 10079487, if finds ALL of the cells, even the ones whose color has been changed by the conditional formatting.

How do we get it to see the conditional formatted color?

If it's set by CF then you need to use

Please Login or Register  to view this content.

Yes! Thank you. You were such a big help with figuring out the root of the problem. Thanks again

You're welcome & thanks for the feedback