Cell C5,D5 and E5 would be the cells that would be highlighted. But I want the ability to only have 1 cell highlighted, i.e. if C5 is highlighted, and then I highlight D5, C5 becomes unhighlighted.Then, dependant on what cell is highlighted, either a 1,2 or 3 is added to G5.