Skipping Coloured Cell when Using Conditional Formatting

Hi,

So someone else helped me out getting the following VBA, which is great and works:

Please Login or Register  to view this content.

However only one tiny problem, the VBA doesn't seem to work on cells that are conditionally formatted using a formula that have the same RGB color.

I have a conditional format that if a cell in a column on another sheet has the letter "X" in it, then the same cell on the current sheet will automatically change to the RGB color. This is working fine. The VBA won't skip these cells however, it will only skip the cells that i manually fill with the selected RGB color, however i don't want to have to manually color these cells.

Is there a way the VBA will work when the conditional formatting is in place too?

Many thanks

Hi PCI,

Thanks for the macro, it seems to be partially working. Except it keeps skipping over two cells at a time, even ones that are white, I only want it to skip the black cells. I've attached a copy of the file with your macro in it. Could you please have a look at it and alter what needs to be done, I would greatly greatly appreciate it.

Apologies this return email has taken months, I've been busy with other stuff and haven't checked.

Thank you!