Hi Team,
I have a specific worksheet with bunch of unique lets say serial numbers. Each serial number has it's own description.
The serial numbers are in Column A
The description is in Column B.
1) I have added Column C with a Vlookup to check the serial numbers that I am getting from another worksheet on a weekly basis and copied them into Sheet1.
The reason is when I have the serial numbers that are matching from Sheet1 with the ones in sheet "Test" those serials need to be highlighted in Green but the problem is that I need the highlighted area to be with all the information I have for this serial number. For example the first serial in my list is 75E395X
I need all rows from Row 2 to Row 16 to be highlighted in Green if this serial is found with the Vlookup formula.
Another condition I need is probably more complicated and I really don't know how to start.
2) Lets take the second serial number 75E3A4M. If for this serial number with matching values from row B at least 3 times Test1 at least 3 times Test 2 and at least 3 times Test3 again to highlight the area for this serial number in Green which is Row 17 to row 31 included. If this can be made we can skip point 1 as it will be the same.
and the last condition I need is:
3) If for a serial number it doesn't see Test3 in Column B but sees at least 3 Times Test1 and at least 3 Times Test 2 to highlight the area in yellow. Lets take Serial: 75E3A4Y
for example and in this case the rows to highlight are Row 32 to Row 41 included.
Does that make sense? Thank you in advance! I am making this by hand one be one and it takes me like 3 hours to complete this worksheet and the serial numbers will get more and more and I want to know if there is a chance to shorten this with formulas!
Bookmarks