In my Worksheet I have 80 columns (80) numbers with over 100 rows.
All numbers (1-80) are mixed in each row using special algorithm.
I picked 20 random numbers between 1 and 80.
My conditional formating formula marks in each row 20 numbers that I
picked.
The conditional formating formula is: =MATCH(A1,$CC$1:$CC$20,0)
I have divided the worksheet in to 2 even parts (40 numbers/columns in
each side).
I want to know if it is possible to make conditional formating or using
other method to show me how many numbers that I have picked is in first
40 cells and how many numbers is in second lot of 40 cells in the same
row.
I would like the formula to disply the result at the end of each row.
Is it possible?
If you need more explanations please let me know.
Thanks in advance for your help.
John


--
Johncobb45
------------------------------------------------------------------------
Johncobb45's Profile: http://www.excelforum.com/member.php...o&userid=16582
View this thread: http://www.excelforum.com/showthread...hreadid=566439

Hi Johncobb45,

If you are trying to count your highlighted cells, take a look at this
link

http://www.ozgrid.com/Excel/count-sum-cell-color.htm

oldchippy ;)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=566439

Hi oldchippy

Thank you for your answer.
I followed the link that you have provided and looked at the User
Defined Functions.
Unfortunately I don't know much about coding.
I don't understand where should I implement the code.
Where do I use it?
Is there any easier "conditional formating formula"?
I also want this formula to count my picked and highlited numbers and
show me how many numbers that I have picked is in first 40 cells and
how many numbers is in the second lot of 40 cells in the same row.
If you need any more explanation please let me know.
Waiting for help.
John


--
Johncobb45
------------------------------------------------------------------------
Johncobb45's Profile: http://www.excelforum.com/member.php...o&userid=16582
View this thread: http://www.excelforum.com/showthread...hreadid=566439