vendredi 16 septembre 2016

Excel: Using IF statement to determine if multiple columns in a row are highlighted

I want to know how I can use an IF statement (or another function) to determine if all the columns pictured below in a particular row are highlighted:

Screenshot of Table

I'm looking to put the function in Column T and return "Buy" if all columns within the row are highlighted.

Thanks in advance

Aucun commentaire:

Enregistrer un commentaire