How do I cause excel to skip number sequence using colour?

I have an example I would like to make a reality with a formula for Column C. Please check the image attached.

SS.jpg

In Column B, I have used a formula to create a naming convention using Column A (check the formula bar in the picture above for reference).

Column C is what my desired result should be at the end. I have just typed the values without formula. But this is how I want them to be after formula.

Essentially I want Column C to skip the lines with red/yellow fill (in Column A & B) and continue the sequence only when cell A and B fill is blank or not yellow/red.

The cells are NOT conditionally formatted. Instead I'm using a VBA function to identify the red and yellow cells:

Please Login or Register  to view this content.

How do I write an IF statement to cause Column C to skip the lines using the red and yellow colored fill in Column A and B? The number sequencing needs to continue as mentioned above. So if ABC123_0001 to ABC123_0003 is blank or coloured NOT yellow or red, then no problem. But if ABC123_0004 is red or yellow, then it must skip this line in Column C. Then if the next cell is not colored red/yellow then it will continue as the new ABC123_0004 and so on. Hope that makes sense.. Refer to the picture for how exactly I want it.

Without condition for yellow/red cells, without VBA, I belive it can not be done with formula.

Yes, I did read it. Formula in column C can not read format of column A or B .

Attachment is invalid. Try to attach worksheet instead.

Column C does not work because code is missing. Try to add the code and upload again.

crossposted: https://www.mrexcel.com/board/thread...olour.1155004/

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

Did you read the link to understand why we ask that you post crosspostings.

Stay the course as you have posted in both and appears to be getting help in both and crosspostings are known.

Try in E2:

Please Login or Register  to view this content.

Drag down