Using excel, I want to highlight
-
cell J10 green if iticontains contains a match in e1:h1
-
Cell k11 I need to have highlighted yellow if it contains a match or duplicate in range e1:h1
I cannot upload a pic as yet so please take the below as an illustration of my excel screen.
A. B. C. D. E. F. G. H. I. J. K.
1. 1. 2. 3. 4. 1. 3. 2. 7. 5. 6. 9. 9. 12 3.
Aucun commentaire:
Enregistrer un commentaire