IF I USED DATA VALIDATION TO CREATE A LIST. CAN I LINK TWO LISTS TOGETHER.
ie: LIST 1 IS ONLY COLORS, AND LIST 2 IS FRUIT. CAN I MAKE THE LISTS LINK
SO AN ERROR POPS UP IF I TRY TO SAY I HAVE A PURPLE, APPLE? WHEREAS THE
PROGRAM KNOWS, BECAUSE MY LISTS ARE LINKED THE ONLY COLOR THAT CAN BE BROUGHT
DOWN IN THE FIRST LIST IS RED. IF I TRY TO USE PURPLE IT WON'T ALLOW ME, OR
AUTOMATICALLY CHANGE IT TO THE COLOR RED.