I want to assign color blue to 3 random cells on the sheet that I type value into. Then I want to assign color yellow to the next 5 random cells that I type value into. so on and so forth.

I don't want to select range of cells to do this on. I simply want the cell fill color that I assign to "stick" on entered data until I change it again while entering my next set of data. I am pulling out my hair trying to figure this simply thing in Excel.

Help is soooo much appreciated.