J
Johncobb45
In my Worksheet I have 80 columns (80) numbers with over 100 rows.
All numbers (1-80) in each row are mixed.
I picked 20 random numbers between 1 and 80.
My conditional formating formula marks in each row 20 numbers that
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 o
each side).
I want to know if it is possible to make conditional formating formul
to show me how many numbers that I have picked is in first 40 cells an
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.
Joh
All numbers (1-80) in each row are mixed.
I picked 20 random numbers between 1 and 80.
My conditional formating formula marks in each row 20 numbers that
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 o
each side).
I want to know if it is possible to make conditional formating formul
to show me how many numbers that I have picked is in first 40 cells an
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.
Joh