if there was a way where the count of cells in yellow could be displayed in the column F.
All yellow cells start BB, Is this always the case? If not, what is the rule for Yellow/Red?