CF help.

[serge]

Hi everyone,

I need a CF formula to format from A2:VX56.

In black, when a number came up 0 time.
In yellow when a number came up 1 time.
In green when a number came up 2 time.

The range of number will start in A1, then the second number will be in B1 then C1,D1 Etc... up to VX1, number will range from 1 to 56, in that row 1.

Thank you in advance for any help. Serge.

 

[GlennUK]

You've said that numbers ranging from 1 to 56 will be the contents of A1:VX1. What are the contents of A2:VX56? Sorry but what you are requesting is not clear.

 

[serge]

Hi GlennUK,

In A2:VX56 those are the data that need to be formatted, according to the numbers in row 1.

In row 1 starting at A1 then B1,C1, etc... those are the cells where new numbers would be added from left to right.

Then below starting A2:A56 are the data that need to be formatted if they came up 0 time or 1 time or 2 time.

For example : Put in A1:A56, 1,2,3,4,5, etc... up to 56.
Then in B1:O1 put those numbers :1,3,10,18,26,18,37,3,9,20,47,3,7,718

In B2 put this formula : =IF(ISERROR(MATCH(A1,B$1:B1,0)),A1,A2)

drag down and across, then you will have exactly my data.

<table style="width: 390px; height: 1008px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 20pt;" width="26" span="5"> <col style="width: 20pt;" width="26" span="10"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl64" style="height: 12.75pt; width: 20pt;" width="26" height="17">1</td> <td class="xl64" style="width: 20pt;" width="26">3</td> <td class="xl64" style="width: 20pt;" width="26">10</td> <td class="xl63" style="width: 20pt;" width="26">18</td> <td class="xl63" style="width: 20pt;" width="26">26</td> <td class="xl63" style="width: 20pt;" width="26">18</td> <td class="xl63" style="width: 20pt;" width="26">37</td> <td class="xl63" style="width: 20pt;" width="26">3</td> <td class="xl63" style="width: 20pt;" width="26">9</td> <td class="xl63" style="width: 20pt;" width="26">20</td> <td class="xl63" style="width: 20pt;" width="26">47</td> <td class="xl63" style="width: 20pt;" width="26">3</td> <td class="xl63" style="width: 20pt;" width="26">7</td> <td class="xl63" style="width: 20pt;" width="26">7</td> <td class="xl63" style="width: 20pt;" width="26">18</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">2</td> <td class="xl66">1</td> <td class="xl66">3</td> <td class="xl66">10</td> <td class="xl63">18</td> <td class="xl63">26</td> <td class="xl63">18</td> <td class="xl63">37</td> <td class="xl63">3</td> <td class="xl63">9</td> <td class="xl63">20</td> <td class="xl63">47</td> <td class="xl63">3</td> <td class="xl63">3</td> <td class="xl63">7</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">3</td> <td class="xl66">2</td> <td class="xl66">1</td> <td class="xl66">3</td> <td class="xl63">10</td> <td class="xl63">10</td> <td class="xl63">26</td> <td class="xl63">18</td> <td class="xl63">37</td> <td class="xl63">3</td> <td class="xl63">9</td> <td class="xl63">20</td> <td class="xl63">47</td> <td class="xl63">47</td> <td class="xl63">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">4</td> <td class="xl66">4</td> <td class="xl66">2</td> <td class="xl66">1</td> <td class="xl63">3</td> <td class="xl63">3</td> <td class="xl63">10</td> <td class="xl63">26</td> <td class="xl63">18</td> <td class="xl63">37</td> <td class="xl63">3</td> <td class="xl63">9</td> <td class="xl63">20</td> <td class="xl63">20</td> <td class="xl63">47</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">5</td> <td class="xl66">5</td> <td class="xl66">4</td> <td class="xl66">2</td> <td class="xl63">1</td> <td class="xl63">1</td> <td class="xl63">3</td> <td class="xl63">10</td> <td class="xl63">26</td> <td class="xl63">18</td> <td class="xl63">37</td> <td class="xl63">37</td> <td class="xl63">9</td> <td class="xl63">9</td> <td class="xl63">20</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">6</td> <td class="xl66">6</td> <td class="xl66">5</td> <td class="xl66">4</td> <td class="xl63">2</td> <td class="xl63">2</td> <td class="xl63">1</td> <td class="xl63">1</td> <td class="xl63">10</td> <td class="xl63">26</td> <td class="xl63">18</td> <td class="xl63">18</td> <td class="xl63">37</td> <td class="xl63">37</td> <td class="xl63">9</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">7</td> <td class="xl66">7</td> <td class="xl66">6</td> <td class="xl66">5</td> <td class="xl63">4</td> <td class="xl63">4</td> <td class="xl63">2</td> <td class="xl63">2</td> <td class="xl63">1</td> <td class="xl63">10</td> <td class="xl63">26</td> <td class="xl63">26</td> <td class="xl63">18</td> <td class="xl63">18</td> <td class="xl63">37</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">8</td> <td class="xl66">8</td> <td class="xl66">7</td> <td class="xl66">6</td> <td class="xl63">5</td> <td class="xl63">5</td> <td class="xl63">4</td> <td class="xl63">4</td> <td class="xl63">2</td> <td class="xl63">1</td> <td class="xl63">10</td> <td class="xl63">10</td> <td class="xl63">26</td> <td class="xl63">26</td> <td class="xl63">26</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">9</td> <td class="xl66">9</td> <td class="xl66">8</td> <td class="xl66">7</td> <td class="xl63">6</td> <td class="xl63">6</td> <td class="xl63">5</td> <td class="xl63">5</td> <td class="xl63">4</td> <td class="xl63">2</td> <td class="xl63">1</td> <td class="xl63">1</td> <td class="xl63">10</td> <td class="xl63">10</td> <td class="xl63">10</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">10</td> <td class="xl66">10</td> <td class="xl66">9</td> <td class="xl66">8</td> <td class="xl63">7</td> <td class="xl63">7</td> <td class="xl63">6</td> <td class="xl63">6</td> <td class="xl63">5</td> <td class="xl63">4</td> <td class="xl63">2</td> <td class="xl63">2</td> <td class="xl63">1</td> <td class="xl63">1</td> <td class="xl63">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">11</td> <td class="xl66">11</td> <td class="xl66">11</td> <td class="xl66">9</td> <td class="xl63">8</td> <td class="xl63">8</td> <td class="xl63">7</td> <td class="xl63">7</td> <td class="xl63">6</td> <td class="xl63">5</td> <td class="xl63">4</td> <td class="xl63">4</td> <td class="xl63">2</td> <td class="xl63">2</td> <td class="xl63">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">12</td> <td class="xl66">12</td> <td class="xl66">12</td> <td class="xl66">11</td> <td class="xl63">9</td> <td class="xl63">9</td> <td class="xl63">8</td> <td class="xl63">8</td> <td class="xl63">7</td> <td class="xl63">6</td> <td class="xl63">5</td> <td class="xl63">5</td> <td class="xl63">4</td> <td class="xl63">4</td> <td class="xl63">4</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">13</td> <td class="xl66">13</td> <td class="xl66">13</td> <td class="xl66">12</td> <td class="xl63">11</td> <td class="xl63">11</td> <td class="xl63">9</td> <td class="xl63">9</td> <td class="xl63">8</td> <td class="xl63">7</td> <td class="xl63">6</td> <td class="xl63">6</td> <td class="xl63">5</td> <td class="xl63">5</td> <td class="xl63">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">14</td> <td class="xl66">14</td> <td class="xl66">14</td> <td class="xl66">13</td> <td class="xl63">12</td> <td class="xl63">12</td> <td class="xl63">11</td> <td class="xl63">11</td> <td class="xl63">11</td> <td class="xl63">8</td> <td class="xl63">7</td> <td class="xl63">7</td> <td class="xl63">6</td> <td class="xl63">6</td> <td class="xl63">6</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">15</td> <td class="xl66">15</td> <td class="xl66">15</td> <td class="xl66">14</td> <td class="xl63">13</td> <td class="xl63">13</td> <td class="xl63">12</td> <td class="xl63">12</td> <td class="xl63">12</td> <td class="xl63">11</td> <td class="xl63">8</td> <td class="xl63">8</td> <td class="xl63">8</td> <td class="xl63">8</td> <td class="xl63">8</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">16</td> <td class="xl66">16</td> <td class="xl66">16</td> <td class="xl66">15</td> <td class="xl63">14</td> <td class="xl63">14</td> <td class="xl63">13</td> <td class="xl63">13</td> <td class="xl63">13</td> <td class="xl63">12</td> <td class="xl63">11</td> <td class="xl63">11</td> <td class="xl63">11</td> <td class="xl63">11</td> <td class="xl63">11</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">17</td> <td class="xl66">17</td> <td class="xl66">17</td> <td class="xl66">16</td> <td class="xl63">15</td> <td class="xl63">15</td> <td class="xl63">14</td> <td class="xl63">14</td> <td class="xl63">14</td> <td class="xl63">13</td> <td class="xl63">12</td> <td class="xl63">12</td> <td class="xl63">12</td> <td class="xl63">12</td> <td class="xl63">12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">18</td> <td class="xl66">18</td> <td class="xl66">18</td> <td class="xl66">17</td> <td class="xl63">16</td> <td class="xl63">16</td> <td class="xl63">15</td> <td class="xl63">15</td> <td class="xl63">15</td> <td class="xl63">14</td> <td class="xl63">13</td> <td class="xl63">13</td> <td class="xl63">13</td> <td class="xl63">13</td> <td class="xl63">13</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">19</td> <td class="xl66">19</td> <td class="xl66">19</td> <td class="xl66">19</td> <td class="xl63">17</td> <td class="xl63">17</td> <td class="xl63">16</td> <td class="xl63">16</td> <td class="xl63">16</td> <td class="xl63">15</td> <td class="xl63">14</td> <td class="xl63">14</td> <td class="xl63">14</td> <td class="xl63">14</td> <td class="xl63">14</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">20</td> <td class="xl66">20</td> <td class="xl66">20</td> <td class="xl66">20</td> <td class="xl63">19</td> <td class="xl63">19</td> <td class="xl63">17</td> <td class="xl63">17</td> <td class="xl63">17</td> <td class="xl63">16</td> <td class="xl63">15</td> <td class="xl63">15</td> <td class="xl63">15</td> <td class="xl63">15</td> <td class="xl63">15</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">21</td> <td class="xl66">21</td> <td class="xl66">21</td> <td class="xl66">21</td> <td class="xl63">20</td> <td class="xl63">20</td> <td class="xl63">19</td> <td class="xl63">19</td> <td class="xl63">19</td> <td class="xl63">17</td> <td class="xl63">16</td> <td class="xl63">16</td> <td class="xl63">16</td> <td class="xl63">16</td> <td class="xl63">16</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">22</td> <td class="xl66">22</td> <td class="xl66">22</td> <td class="xl66">22</td> <td class="xl63">21</td> <td class="xl63">21</td> <td class="xl63">20</td> <td class="xl63">20</td> <td class="xl63">20</td> <td class="xl63">19</td> <td class="xl63">17</td> <td class="xl63">17</td> <td class="xl63">17</td> <td class="xl63">17</td> <td class="xl63">17</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">23</td> <td class="xl66">23</td> <td class="xl66">23</td> <td class="xl66">23</td> <td class="xl63">22</td> <td class="xl63">22</td> <td class="xl63">21</td> <td class="xl63">21</td> <td class="xl63">21</td> <td class="xl63">21</td> <td class="xl63">19</td> <td class="xl63">19</td> <td class="xl63">19</td> <td class="xl63">19</td> <td class="xl63">19</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">24</td> <td class="xl66">24</td> <td class="xl66">24</td> <td class="xl66">24</td> <td class="xl63">23</td> <td class="xl63">23</td> <td class="xl63">22</td> <td class="xl63">22</td> <td class="xl63">22</td> <td class="xl63">22</td> <td class="xl63">21</td> <td class="xl63">21</td> <td class="xl63">21</td> <td class="xl63">21</td> <td class="xl63">21</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">25</td> <td class="xl66">25</td> <td class="xl66">25</td> <td class="xl66">25</td> <td class="xl63">24</td> <td class="xl63">24</td> <td class="xl63">23</td> <td class="xl63">23</td> <td class="xl63">23</td> <td class="xl63">23</td> <td class="xl63">22</td> <td class="xl63">22</td> <td class="xl63">22</td> <td class="xl63">22</td> <td class="xl63">22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">26</td> <td class="xl66">26</td> <td class="xl66">26</td> <td class="xl66">26</td> <td class="xl63">25</td> <td class="xl63">25</td> <td class="xl63">24</td> <td class="xl63">24</td> <td class="xl63">24</td> <td class="xl63">24</td> <td class="xl63">23</td> <td class="xl63">23</td> <td class="xl63">23</td> <td class="xl63">23</td> <td class="xl63">23</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">27</td> <td class="xl66">27</td> <td class="xl66">27</td> <td class="xl66">27</td> <td class="xl63">27</td> <td class="xl63">27</td> <td class="xl63">25</td> <td class="xl63">25</td> <td class="xl63">25</td> <td class="xl63">25</td> <td class="xl63">24</td> <td class="xl63">24</td> <td class="xl63">24</td> <td class="xl63">24</td> <td class="xl63">24</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">28</td> <td class="xl66">28</td> <td class="xl66">28</td> <td class="xl66">28</td> <td class="xl63">28</td> <td class="xl63">28</td> <td class="xl63">27</td> <td class="xl63">27</td> <td class="xl63">27</td> <td class="xl63">27</td> <td class="xl63">25</td> <td class="xl63">25</td> <td class="xl63">25</td> <td class="xl63">25</td> <td class="xl63">25</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">29</td> <td class="xl66">29</td> <td class="xl66">29</td> <td class="xl66">29</td> <td class="xl63">29</td> <td class="xl63">29</td> <td class="xl63">28</td> <td class="xl63">28</td> <td class="xl63">28</td> <td class="xl63">28</td> <td class="xl63">27</td> <td class="xl63">27</td> <td class="xl63">27</td> <td class="xl63">27</td> <td class="xl63">27</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">30</td> <td class="xl66">30</td> <td class="xl66">30</td> <td class="xl66">30</td> <td class="xl63">30</td> <td class="xl63">30</td> <td class="xl63">29</td> <td class="xl63">29</td> <td class="xl63">29</td> <td class="xl63">29</td> <td class="xl63">28</td> <td class="xl63">28</td> <td class="xl63">28</td> <td class="xl63">28</td> <td class="xl63">28</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">31</td> <td class="xl66">31</td> <td class="xl66">31</td> <td class="xl66">31</td> <td class="xl63">31</td> <td class="xl63">31</td> <td class="xl63">30</td> <td class="xl63">30</td> <td class="xl63">30</td> <td class="xl63">30</td> <td class="xl63">29</td> <td class="xl63">29</td> <td class="xl63">29</td> <td class="xl63">29</td> <td class="xl63">29</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">32</td> <td class="xl66">32</td> <td class="xl66">32</td> <td class="xl66">32</td> <td class="xl63">32</td> <td class="xl63">32</td> <td class="xl63">31</td> <td class="xl63">31</td> <td class="xl63">31</td> <td class="xl63">31</td> <td class="xl63">30</td> <td class="xl63">30</td> <td class="xl63">30</td> <td class="xl63">30</td> <td class="xl63">30</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">33</td> <td class="xl66">33</td> <td class="xl66">33</td> <td class="xl66">33</td> <td class="xl63">33</td> <td class="xl63">33</td> <td class="xl63">32</td> <td class="xl63">32</td> <td class="xl63">32</td> <td class="xl63">32</td> <td class="xl63">31</td> <td class="xl63">31</td> <td class="xl63">31</td> <td class="xl63">31</td> <td class="xl63">31</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">34</td> <td class="xl66">34</td> <td class="xl66">34</td> <td class="xl66">34</td> <td class="xl63">34</td> <td class="xl63">34</td> <td class="xl63">33</td> <td class="xl63">33</td> <td class="xl63">33</td> <td class="xl63">33</td> <td class="xl63">32</td> <td class="xl63">32</td> <td class="xl63">32</td> <td class="xl63">32</td> <td class="xl63">32</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">35</td> <td class="xl66">35</td> <td class="xl66">35</td> <td class="xl66">35</td> <td class="xl63">35</td> <td class="xl63">35</td> <td class="xl63">34</td> <td class="xl63">34</td> <td class="xl63">34</td> <td class="xl63">34</td> <td class="xl63">33</td> <td class="xl63">33</td> <td class="xl63">33</td> <td class="xl63">33</td> <td class="xl63">33</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">36</td> <td class="xl66">36</td> <td class="xl66">36</td> <td class="xl66">36</td> <td class="xl63">36</td> <td class="xl63">36</td> <td class="xl63">35</td> <td class="xl63">35</td> <td class="xl63">35</td> <td class="xl63">35</td> <td class="xl63">34</td> <td class="xl63">34</td> <td class="xl63">34</td> <td class="xl63">34</td> <td class="xl63">34</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">37</td> <td class="xl66">37</td> <td class="xl66">37</td> <td class="xl66">37</td> <td class="xl63">37</td> <td class="xl63">37</td> <td class="xl63">36</td> <td class="xl63">36</td> <td class="xl63">36</td> <td class="xl63">36</td> <td class="xl63">35</td> <td class="xl63">35</td> <td class="xl63">35</td> <td class="xl63">35</td> <td class="xl63">35</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">38</td> <td class="xl66">38</td> <td class="xl66">38</td> <td class="xl66">38</td> <td class="xl63">38</td> <td class="xl63">38</td> <td class="xl63">38</td> <td class="xl63">38</td> <td class="xl63">38</td> <td class="xl63">38</td> <td class="xl63">36</td> <td class="xl63">36</td> <td class="xl63">36</td> <td class="xl63">36</td> <td class="xl63">36</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">39</td> <td class="xl66">39</td> <td class="xl66">39</td> <td class="xl66">39</td> <td class="xl63">39</td> <td class="xl63">39</td> <td class="xl63">39</td> <td class="xl63">39</td> <td class="xl63">39</td> <td class="xl63">39</td> <td class="xl63">38</td> <td class="xl63">38</td> <td class="xl63">38</td> <td class="xl63">38</td> <td class="xl63">38</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">40</td> <td class="xl66">40</td> <td class="xl66">40</td> <td class="xl66">40</td> <td class="xl63">40</td> <td class="xl63">40</td> <td class="xl63">40</td> <td class="xl63">40</td> <td class="xl63">40</td> <td class="xl63">40</td> <td class="xl63">39</td> <td class="xl63">39</td> <td class="xl63">39</td> <td class="xl63">39</td> <td class="xl63">39</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">41</td> <td class="xl66">41</td> <td class="xl66">41</td> <td class="xl66">41</td> <td class="xl63">41</td> <td class="xl63">41</td> <td class="xl63">41</td> <td class="xl63">41</td> <td class="xl63">41</td> <td class="xl63">41</td> <td class="xl63">40</td> <td class="xl63">40</td> <td class="xl63">40</td> <td class="xl63">40</td> <td class="xl63">40</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">42</td> <td class="xl66">42</td> <td class="xl66">42</td> <td class="xl66">42</td> <td class="xl63">42</td> <td class="xl63">42</td> <td class="xl63">42</td> <td class="xl63">42</td> <td class="xl63">42</td> <td class="xl63">42</td> <td class="xl63">41</td> <td class="xl63">41</td> <td class="xl63">41</td> <td class="xl63">41</td> <td class="xl63">41</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">43</td> <td class="xl66">43</td> <td class="xl66">43</td> <td class="xl66">43</td> <td class="xl63">43</td> <td class="xl63">43</td> <td class="xl63">43</td> <td class="xl63">43</td> <td class="xl63">43</td> <td class="xl63">43</td> <td class="xl63">42</td> <td class="xl63">42</td> <td class="xl63">42</td> <td class="xl63">42</td> <td class="xl63">42</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">44</td> <td class="xl66">44</td> <td class="xl66">44</td> <td class="xl66">44</td> <td class="xl63">44</td> <td class="xl63">44</td> <td class="xl63">44</td> <td class="xl63">44</td> <td class="xl63">44</td> <td class="xl63">44</td> <td class="xl63">43</td> <td class="xl63">43</td> <td class="xl63">43</td> <td class="xl63">43</td> <td class="xl63">43</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">45</td> <td class="xl66">45</td> <td class="xl66">45</td> <td class="xl66">45</td> <td class="xl63">45</td> <td class="xl63">45</td> <td class="xl63">45</td> <td class="xl63">45</td> <td class="xl63">45</td> <td class="xl63">45</td> <td class="xl63">44</td> <td class="xl63">44</td> <td class="xl63">44</td> <td class="xl63">44</td> <td class="xl63">44</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">46</td> <td class="xl66">46</td> <td class="xl66">46</td> <td class="xl66">46</td> <td class="xl63">46</td> <td class="xl63">46</td> <td class="xl63">46</td> <td class="xl63">46</td> <td class="xl63">46</td> <td class="xl63">46</td> <td class="xl63">45</td> <td class="xl63">45</td> <td class="xl63">45</td> <td class="xl63">45</td> <td class="xl63">45</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">47</td> <td class="xl66">47</td> <td class="xl66">47</td> <td class="xl66">47</td> <td class="xl63">47</td> <td class="xl63">47</td> <td class="xl63">47</td> <td class="xl63">47</td> <td class="xl63">47</td> <td class="xl63">47</td> <td class="xl63">46</td> <td class="xl63">46</td> <td class="xl63">46</td> <td class="xl63">46</td> <td class="xl63">46</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">48</td> <td class="xl66">48</td> <td class="xl66">48</td> <td class="xl66">48</td> <td class="xl63">48</td> <td class="xl63">48</td> <td class="xl63">48</td> <td class="xl63">48</td> <td class="xl63">48</td> <td class="xl63">48</td> <td class="xl63">48</td> <td class="xl63">48</td> <td class="xl63">48</td> <td class="xl63">48</td> <td class="xl63">48</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">49</td> <td class="xl66">49</td> <td class="xl66">49</td> <td class="xl66">49</td> <td class="xl63">49</td> <td class="xl63">49</td> <td class="xl63">49</td> <td class="xl63">49</td> <td class="xl63">49</td> <td class="xl63">49</td> <td class="xl63">49</td> <td class="xl63">49</td> <td class="xl63">49</td> <td class="xl63">49</td> <td class="xl63">49</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">50</td> <td class="xl66">50</td> <td class="xl66">50</td> <td class="xl66">50</td> <td class="xl63">50</td> <td class="xl63">50</td> <td class="xl63">50</td> <td class="xl63">50</td> <td class="xl63">50</td> <td class="xl63">50</td> <td class="xl63">50</td> <td class="xl63">50</td> <td class="xl63">50</td> <td class="xl63">50</td> <td class="xl63">50</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">51</td> <td class="xl66">51</td> <td class="xl66">51</td> <td class="xl66">51</td> <td class="xl63">51</td> <td class="xl63">51</td> <td class="xl63">51</td> <td class="xl63">51</td> <td class="xl63">51</td> <td class="xl63">51</td> <td class="xl63">51</td> <td class="xl63">51</td> <td class="xl63">51</td> <td class="xl63">51</td> <td class="xl63">51</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">52</td> <td class="xl66">52</td> <td class="xl66">52</td> <td class="xl66">52</td> <td class="xl63">52</td> <td class="xl63">52</td> <td class="xl63">52</td> <td class="xl63">52</td> <td class="xl63">52</td> <td class="xl63">52</td> <td class="xl63">52</td> <td class="xl63">52</td> <td class="xl63">52</td> <td class="xl63">52</td> <td class="xl63">52</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">53</td> <td class="xl66">53</td> <td class="xl66">53</td> <td class="xl66">53</td> <td class="xl63">53</td> <td class="xl63">53</td> <td class="xl63">53</td> <td class="xl63">53</td> <td class="xl63">53</td> <td class="xl63">53</td> <td class="xl63">53</td> <td class="xl63">53</td> <td class="xl63">53</td> <td class="xl63">53</td> <td class="xl63">53</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">54</td> <td class="xl66">54</td> <td class="xl66">54</td> <td class="xl66">54</td> <td class="xl63">54</td> <td class="xl63">54</td> <td class="xl63">54</td> <td class="xl63">54</td> <td class="xl63">54</td> <td class="xl63">54</td> <td class="xl63">54</td> <td class="xl63">54</td> <td class="xl63">54</td> <td class="xl63">54</td> <td class="xl63">54</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">55</td> <td class="xl66">55</td> <td class="xl66">55</td> <td class="xl66">55</td> <td class="xl63">55</td> <td class="xl63">55</td> <td class="xl63">55</td> <td class="xl63">55</td> <td class="xl63">55</td> <td class="xl63">55</td> <td class="xl63">55</td> <td class="xl63">55</td> <td class="xl63">55</td> <td class="xl63">55</td> <td class="xl63">55</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">56</td> <td class="xl66">56</td> <td class="xl66">56</td> <td class="xl66">56</td> <td class="xl63">56</td> <td class="xl63">56</td> <td class="xl63">56</td> <td class="xl63">56</td> <td class="xl63">56</td> <td class="xl63">56</td> <td class="xl63">56</td> <td class="xl63">56</td> <td class="xl63">56</td> <td class="xl63">56</td> <td class="xl63">56</td> </tr> </tbody></table>
So starting from the top down all the numbers that haven't show up yet in row1 should be in black, then ( in this example ) number : 1,3,10,18 etc.. should be in yellow until it come up for a 2nd time.

The number 18 in F1 appear for the 2nd time so it should become green and stay green in all the following column until it come up for a 3rd time then it become white ( no color ) and also the same for number 3 in H1 Etc...

I know it look a bit confusing but when you understand it's simple.

I hope you can help me with it ?

That would be really appreciated... Serge.

 

[serge]

Can someone look at it and see if you can ifgure it out ?
If you need more explanations please let me know.

Thank you. Serge.

 

[GlennUK]

No, it is still not clear.

Are you testing in each column? Or is the testing for all cells above and to the left of the current cell? Or is it per row?

How can the number 18 be green and "stay green in all the following column"? Won't the following columns be coloured according to their contents?

 

[serge]

Let me explain in a different way.

The way I read those data are by column.

All the numbers in row 1, are the numbers to be found in the 1 column before that number.

To start all the numbers in column A1:A56 should be in black.( this is the starting point ).

Then the way I read it, is like this :

The number : 3 in B1 need to be found in column A1:A56 which is in cell : A3.

This number 3 should become yellow because it's been selected in B1 for the first time, and stay yellow in all the other columns as we go father ahead until, it will be selected for a 2nd time somewhere in that same row 1.

Number 10 in C1 need to be found in column B1:B56, in that column all numbers should be black except 3 and 10 ( in yellow).

Number 18 in D1 should be found in column C1:C56 which is in cell : C18 and become yellow, in this column C, all numbers should be in black except 3,10,18.

Then same for number 26 in E1 need to become yellow in column D. as 3,10,18.

Number 18 in F1 appear for the 2nd time so now this number should become Green in column E. and 3,10,26 stay in yellow.

That's it, I hope now I explained it better.

Thank you.... Regards... Serge.