New

=SUM(COUNTIF(A2,""&MYLIST&"")) FORMULA FOR CONDITIONAL FORMATTING

Excel

raquelking1

Wednesday, 27 June 2018

0 Replies

2.9K Visits

Votes

Undo

I USED THIS AND IT WORKED BUT IT DIDN'T HIGHLIGHT SOME CELLS THAT SHOULD HAVE BEEN. IT SEEMS LIKE IT MAY HAVE ONLY HIGHLIGHTED ONE OF EACH OCCURRENCE. ANY HELP?

There are no replies made for this post yet.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

=SUM(COUNTIF(A2,"*"&MYLIST&"*")) FORMULA FOR CONDITIONAL FORMATTING

=SUM(COUNTIF(A2,""&MYLIST&"")) FORMULA FOR CONDITIONAL FORMATTING