To get right color
Hello guys My question is about to get the right color. I have 2 columns named Shelf and Tray and values inside those columns. So depends on sum of values in columns I want to have different colors in next column(say column Status). It look like this: Shelf Tray Status 1 1 1 1 1 1 1 2 1 2 1 3 So if I have Shelf and Tray with values 1 (3 times) I want to have red color in Status column. If I have Shelf and Tray with values 1 and 2 (2 times I want to have yellow color in Status column) and If I have Shelf and Tray with values 1 and 3(only 1 time, I want to have green color in Status column). This means 3 times with same values don't have free space for more, 2 times means it is 1 free space and 1 times means 2 free space. If someone knows how to fix this in Vba excel or C#, maybe with If else statement or loop. Thanks in advance.