Hi there,
Please help me with the following excel problem..
say I have 50 rows of lottory numbers (tickets)
and there is this last draw of lottary nums.
2-10-27-30-32-54
I want to highlight all matching numbers in a say blue color..
I tried some formulas but it did not work for me ?
countif(....)
please have a look at the attached file and send me a working one.
thanks.




Reply With Quote