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:
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.
Bookmarks