I am trying to make a cell change color automatically based off of if data is
entered into another cell. But I also want that cell color to be based off of
what cell the data is entered in. For example: If I enter data into cell G8,
I want cell I11 to turn yellow. But when I enter data into G9, I want the
cell to turn green, and so on. Is there any way to do this?