I am trying to figure out how to get other cells to change a color once anything is entered into them. I have tryed conditional formating but that only allows for specific text not variable.