Looking for color in column and msgbox

Hi all,

I need macro to check the range L3:L2500 for colorindex = 3 and if its found show the massege box or if not then go next.

Try this:

Please Login or Register  to view this content.

Stop with

Please Login or Register  to view this content.

"out of range"

Change sheet name Sheet3 to your real sheet name.

I did it zbor. That's the full code I want to use it:

Please Login or Register  to view this content.

I think I now the problem. If I fill the color manual then works ok, but when the color is from Conditional Formating then it's not.

Yes. Works if cell is colored in red.
For Conditional Formatting why don't you use CF criteria to check your data?

That's what I do. CF is checking the match between column K&L and if its different then colour in red. And the macro above is printing me report. But I'm not suppose to do that when red colour is in L. That why I wanted to add the msgbox before my code. Is there anything I can do about it?

Upload example workbook.
Make sure to remove all private informations but leave only what's important to understend problem.

Your sheet is protected

Sorry protection removed ;-)

Solus Rankin this is what I was looking for. Didn't think that way - excellent.
Thank you all for help.
Problem SOLVED.