CF Highlighting number from list in different order.

[serge]

How can those numbers from row 43 be highlighted from the list in row 45.

Excel Workbook
	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS
43	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35
44
45	9	12	1	10	14	21	15	5
Sheet1

Thank you.

 

[CWatts]

In cell K1, use this conditional formula for conditional formatting:

=NOT(ISERROR(MATCH(K43,45:45,0)))

If you don't want the entire row 45 to be checked for numbers, change the 45:45 to the range cells containing your numbers you want to match (such as $K$45:$R$45)

 

[markmzz]

Try this:

<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>A</TH><TH>B</TH><TH>C</TH><TH>D</TH><TH>E</TH><TH>F</TH><TH>G</TH><TH>H</TH><TH>I</TH><TH>J</TH><TH>K</TH><TH>L</TH><TH>M</TH><TH>N</TH><TH>O</TH><TH>P</TH><TH>Q</TH><TH>R</TH><TH>S</TH><TH>T</TH><TH>U</TH><TH>V</TH><TH>W</TH><TH>X</TH><TH>Y</TH><TH>Z</TH><TH>AA</TH><TH>AB</TH><TH>AC</TH><TH>AD</TH><TH>AE</TH><TH>AF</TH><TH>AG</TH><TH>AH</TH><TH>AI</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #00b050">1</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #00b050">5</TD><TD style="TEXT-ALIGN: right">6</TD><TD style="TEXT-ALIGN: right">7</TD><TD style="TEXT-ALIGN: right">8</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #00b050">9</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #00b050">10</TD><TD style="TEXT-ALIGN: right">11</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #00b050">12</TD><TD style="TEXT-ALIGN: right">13</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #00b050">14</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #00b050">15</TD><TD style="TEXT-ALIGN: right">16</TD><TD style="TEXT-ALIGN: right">17</TD><TD style="TEXT-ALIGN: right">18</TD><TD style="TEXT-ALIGN: right">19</TD><TD style="TEXT-ALIGN: right">20</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #00b050">21</TD><TD style="TEXT-ALIGN: right">22</TD><TD style="TEXT-ALIGN: right">23</TD><TD style="TEXT-ALIGN: right">24</TD><TD style="TEXT-ALIGN: right">25</TD><TD style="TEXT-ALIGN: right">26</TD><TD style="TEXT-ALIGN: right">27</TD><TD style="TEXT-ALIGN: right">28</TD><TD style="TEXT-ALIGN: right">29</TD><TD style="TEXT-ALIGN: right">30</TD><TD style="TEXT-ALIGN: right">31</TD><TD style="TEXT-ALIGN: right">32</TD><TD style="TEXT-ALIGN: right">33</TD><TD style="TEXT-ALIGN: right">34</TD><TD style="TEXT-ALIGN: right">35</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD style="TEXT-ALIGN: right">9</TD><TD style="TEXT-ALIGN: right">12</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">14</TD><TD style="TEXT-ALIGN: right">21</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">5</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR></TBODY></TABLE>


CF - =SUM(--(A1=$A$3:$H$3))>0


Markmzz

 

[serge]

Thank you guys for the help both formula work great.

Serge.

 

[T. Valko]

In cell K1, use this conditional formula for conditional formatting:

=NOT(ISERROR(MATCH(K43,45:45,0)))

If you don't want the entire row 45 to be checked for numbers, change the 45:45 to the range cells containing your numbers you want to match (such as $K$45:$R$45)

You don't need that NOT(ISERROR junk.

=MATCH(K43,$K45:$R45,0)

 

[serge]

Thank you Valko,

Your formula look more simple, and easier for me to understand.
Thanks a lot.

Serge.

 

[T. Valko]

Thank you Valko,

Your formula look more simple, and easier for me to understand.
Thanks a lot.

Serge.

You're welcome. Thanks for the feedback!