jeudi 13 septembre 2018

Show status based on how many times a word appears in a range

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