I am trying to build a check and balance into a certificate of conformance (C of C) form. the form is based upon lot number and uses vlookup to populate appropriate cells. I have the ability to list the results for 3 lots on the is form.
what I want to do is to use conditional formating to color a cell red if the 2 and/or 3 lot entered are not from the same product set.
Eg. C13 has the vlookup result for lot #1 which is also the "title" for the C of C. the lot #2 and lot #3 results are listed in a table along side the results of lot #1 below. Results include lot number, and all of the various tests we conduct like thickness, weight, etc. and the specification for lot #1
the way it stands right now, lots #2 and #3 could be different products and unless reviewed by the author, could go out to the customer with erroneous information.
I am looking for a simple conditional format formula to compare the result of lot #1 vlookup against lots #2 and #3. I have tried =c13=j27 (j27 is my test area for now) and =c13<>j27 and they don't work. Any other ideas?
what I want to do is to use conditional formating to color a cell red if the 2 and/or 3 lot entered are not from the same product set.
Eg. C13 has the vlookup result for lot #1 which is also the "title" for the C of C. the lot #2 and lot #3 results are listed in a table along side the results of lot #1 below. Results include lot number, and all of the various tests we conduct like thickness, weight, etc. and the specification for lot #1
the way it stands right now, lots #2 and #3 could be different products and unless reviewed by the author, could go out to the customer with erroneous information.
I am looking for a simple conditional format formula to compare the result of lot #1 vlookup against lots #2 and #3. I have tried =c13=j27 (j27 is my test area for now) and =c13<>j27 and they don't work. Any other ideas?