new here so be polite please :)
I've a column with different words , now I want to give a status based on how many words there are in that range. Here is an example, Column B contains of four rows with a rolling curtain which gives three different choices, apples, bananas and orange. Now I want to give a status based on how many times a banana is selected. For an example if banana is selected >=2 and orange=1 and apple=1 status will be green.
Is there anyone that could help me with that?
Aucun commentaire:
Enregistrer un commentaire