ich habe eine größere Tabelle, in der die Bedingte Formatierung einfach "falsch" zugeordnet wird. Falsch in der Hinsicht, dass die Farbenzuordnung immer in der Zelle davor zugewiesen wird. Worin liegt der Fehler?
<b>FF-Tickets+PF_12.2020</b><br /><br /><table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:52.8px;" /><col style="width:80px;" /><col style="width:72.8px;" /><col style="width:156px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >B</td><td >C</td><td >E</td><td >F</td></tr><tr style="height:23px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >276</td><td style="text-align:right; ">7</td><td style="background-color:#ffff00; text-align:right; ">233374</td><td > </td><td >approve</td></tr><tr style="height:24px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >277</td><td > </td><td style="text-align:right; ">232800</td><td style="color:#ff0000; font-weight:bold; text-align:right; ">04.02.2021</td><td >Korrektur disapproved</td></tr><tr style="height:23px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >278</td><td style="text-align:right; ">1</td><td style="text-align:right; ">233667</td><td > </td><td >risk evaluation</td></tr><tr style="height:23px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >279</td><td style="text-align:right; ">2</td><td style="text-align:right; ">233979</td><td > </td><td >approve</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >280</td><td style="text-align:right; ">3</td><td style="text-align:right; ">233986</td><td > </td><td >approve</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >281</td><td style="text-align:right; ">4</td><td style="text-align:right; ">230063</td><td > </td><td >approve+implement</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >282</td><td style="text-align:right; ">5</td><td style="text-align:right; ">233627</td><td > </td><td >approve+implement</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >283</td><td style="text-align:right; ">6</td><td style="text-align:right; ">234031</td><td > </td><td style="background-color:#000000; ">reject</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >284</td><td style="text-align:right; ">7</td><td style="background-color:#ffff00; text-align:right; ">228337</td><td > </td><td >approve+implement</td></tr><tr style="height:23px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >285</td><td > </td><td style="text-align:right; ">171377</td><td > </td><td >Korrektur disapproved</td></tr><tr style="height:24px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >286</td><td style="text-align:right; ">1</td><td style="background-color:#7030a0; text-align:right; ">232649</td><td style="color:#ff0000; font-weight:bold; text-align:right; ">05.02.2021</td><td >approve</td></tr><tr style="height:23px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >287</td><td style="text-align:right; ">2</td><td style="text-align:right; ">234194</td><td > </td><td >suspected High Risk</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; background-color:#fffcf9; border-style: groove ;border-color:#ff0000"><tr><td ><b>Bedingte Formatierungen der Tabelle</b></td></tr><tr><td ><table border="1" cellspacing="0" style="font-family:Arial; font-size:10pt; "><tr><td >Zelle</td><td >Nr.: / Bedingung</td><td >Format</td></tr><tr><td >C276</td><td >1. / Formel ist =F2:F1500="Korrektur disapproved"</td><td style="background-color:#ffff00; ">Abc</td></tr><tr><td >C276</td><td >2. / Formel ist =F2:F1500="suspected High Risk"</td><td style="background-color:#7030a0; ">Abc</td></tr><tr><td >C276</td><td >3. / Formel ist =F2:F1500="risk evaluation"</td><td style="background-color:#ff0000; ">Abc</td></tr><tr><td >C276</td><td >4. / Eindeutige Werte</td><td style="color:#9c0006; background-color:#ffc7ce; ">Abc</td></tr><tr><td >F276</td><td >1. / Textzeichenfolge</td><td style="color:#ff0000; font-weight:bold; font-style:italic; background-color:#000000; ">Abc</td></tr><tr><td >C277</td><td >1. / Formel ist =F2:F1500="Korrektur disapproved"</td><td style="background-color:#ffff00; ">Abc</td></tr><tr><td >C277</td><td >2. / Formel ist =F2:F1500="suspected High Risk"</td><td style="background-color:#7030a0; ">Abc</td></tr><tr><td >C277</td><td >3. / Formel ist =F2:F1500="risk evaluation"</td><td style="background-color:#ff0000; ">Abc</td></tr><tr><td >C277</td><td >4. / Eindeutige Werte</td><td style="color:#9c0006; background-color:#ffc7ce; ">Abc</td></tr><tr><td >F277</td><td >1. / Textzeichenfolge</td><td style="color:#ff0000; font-weight:bold; font-style:italic; background-color:#000000; ">Abc</td></tr><tr><td >C278</td><td >1. / Formel ist =F2:F1500="Korrektur disapproved"</td><td style="background-color:#ffff00; ">Abc</td></tr><tr><td >C278</td><td >2. / Formel ist =F2:F1500="suspected High Risk"</td><td style="background-color:#7030a0; ">Abc</td></tr><tr><td >C278</td><td >3. / Formel ist =F2:F1500="risk evaluation"</td><td style="background-color:#ff0000; ">Abc</td></tr><tr><td >C278</td><td >4. / Eindeutige Werte</td><td style="color:#9c0006; background-color:#ffc7ce; ">Abc</td></tr><tr><td >F278</td><td >1. / Textzeichenfolge</td><td style="color:#ff0000; font-weight:bold; font-style:italic; background-color:#000000; ">Abc</td></tr><tr><td >C279</td><td >1. / Formel ist =F2:F1500="Korrektur disapproved"</td><td style="background-color:#ffff00; ">Abc</td></tr><tr><td >C279</td><td >2. / Formel ist =F2:F1500="suspected High Risk"</td><td style="background-color:#7030a0; ">Abc</td></tr><tr><td >C279</td><td >3. / Formel ist =F2:F1500="risk evaluation"</td><td style="background-color:#ff0000; ">Abc</td></tr><tr><td >C279</td><td >4. / Eindeutige Werte</td><td style="color:#9c0006; background-color:#ffc7ce; ">Abc</td></tr><tr><td >F279</td><td >1. / Textzeichenfolge</td><td style="color:#ff0000; font-weight:bold; font-style:italic; background-color:#000000; ">Abc</td></tr><tr><td >C280</td><td >1. / Formel ist =F2:F1500="Korrektur disapproved"</td><td style="background-color:#ffff00; ">Abc</td></tr><tr><td >C280</td><td >2. / Formel ist =F2:F1500="suspected High Risk"</td><td style="background-color:#7030a0; ">Abc</td></tr><tr><td >C280</td><td >3. / Formel ist =F2:F1500="risk evaluation"</td><td style="background-color:#ff0000; ">Abc</td></tr><tr><td >C280</td><td >4. / Eindeutige Werte</td><td style="color:#9c0006; background-color:#ffc7ce; ">Abc</td></tr><tr><td >F280</td><td >1. / Textzeichenfolge</td><td style="color:#ff0000; font-weight:bold; font-style:italic; background-color:#000000; ">Abc</td></tr><tr><td >C281</td><td >1. / Formel ist =F2:F1500="Korrektur disapproved"</td><td style="background-color:#ffff00; ">Abc</td></tr><tr><td >C281</td><td >2. / Formel ist =F2:F1500="suspected High Risk"</td><td style="background-color:#7030a0; ">Abc</td></tr><tr><td >C281</td><td >3. / Formel ist =F2:F1500="risk evaluation"</td><td style="background-color:#ff0000; ">Abc</td></tr><tr><td >C281</td><td >4. / Eindeutige Werte</td><td style="color:#9c0006; background-color:#ffc7ce; ">Abc</td></tr><tr><td >F281</td><td >1. / Textzeichenfolge</td><td style="color:#ff0000; font-weight:bold; font-style:italic; background-color:#000000; ">Abc</td></tr><tr><td >C282</td><td >1. / Formel ist =F2:F1500="Korrektur disapproved"</td><td style="background-color:#ffff00; ">Abc</td></tr><tr><td >C282</td><td >2. / Formel ist =F2:F1500="suspected High Risk"</td><td style="background-color:#7030a0; ">Abc</td></tr><tr><td >C282</td><td >3. / Formel ist =F2:F1500="risk evaluation"</td><td style="background-color:#ff0000; ">Abc</td></tr><tr><td >C282</td><td >4. / Eindeutige Werte</td><td style="color:#9c0006; background-color:#ffc7ce; ">Abc</td></tr><tr><td >F282</td><td >1. / Textzeichenfolge</td><td style="color:#ff0000; font-weight:bold; font-style:italic; background-color:#000000; ">Abc</td></tr><tr><td >C283</td><td >1. / Formel ist =F2:F1500="Korrektur disapproved"</td><td style="background-color:#ffff00; ">Abc</td></tr><tr><td >C283</td><td >2. / Formel ist =F2:F1500="suspected High Risk"</td><td style="background-color:#7030a0; ">Abc</td></tr><tr><td >C283</td><td >3. / Formel ist =F2:F1500="risk evaluation"</td><td style="background-color:#ff0000; ">Abc</td></tr><tr><td >C283</td><td >4. / Eindeutige Werte</td><td style="color:#9c0006; background-color:#ffc7ce; ">Abc</td></tr><tr><td >F283</td><td >1. / Textzeichenfolge</td><td style="color:#ff0000; font-weight:bold; font-style:italic; background-color:#000000; ">Abc</td></tr><tr><td >C284</td><td >1. / Formel ist =F2:F1500="Korrektur disapproved"</td><td style="background-color:#ffff00; ">Abc</td></tr><tr><td >C284</td><td >2. / Formel ist =F2:F1500="suspected High Risk"</td><td style="background-color:#7030a0; ">Abc</td></tr><tr><td >C284</td><td >3. / Formel ist =F2:F1500="risk evaluation"</td><td style="background-color:#ff0000; ">Abc</td></tr><tr><td >C284</td><td >4. / Eindeutige Werte</td><td style="color:#9c0006; background-color:#ffc7ce; ">Abc</td></tr><tr><td >F284</td><td >1. / Textzeichenfolge</td><td style="color:#ff0000; font-weight:bold; font-style:italic; background-color:#000000; ">Abc</td></tr><tr><td >C285</td><td >1. / Formel ist =F2:F1500="Korrektur disapproved"</td><td style="background-color:#ffff00; ">Abc</td></tr><tr><td >C285</td><td >2. / Formel ist =F2:F1500="suspected High Risk"</td><td style="background-color:#7030a0; ">Abc</td></tr><tr><td >C285</td><td >3. / Formel ist =F2:F1500="risk evaluation"</td><td style="background-color:#ff0000; ">Abc</td></tr><tr><td >C285</td><td >4. / Eindeutige Werte</td><td style="color:#9c0006; background-color:#ffc7ce; ">Abc</td></tr><tr><td >F285</td><td >1. / Textzeichenfolge</td><td style="color:#ff0000; font-weight:bold; font-style:italic; background-color:#000000; ">Abc</td></tr><tr><td >C286</td><td >1. / Formel ist =F2:F1500="Korrektur disapproved"</td><td style="background-color:#ffff00; ">Abc</td></tr><tr><td >C286</td><td >2. / Formel ist =F2:F1500="suspected High Risk"</td><td style="background-color:#7030a0; ">Abc</td></tr><tr><td >C286</td><td >3. / Formel ist =F2:F1500="risk evaluation"</td><td style="background-color:#ff0000; ">Abc</td></tr><tr><td >C286</td><td >4. / Eindeutige Werte</td><td style="color:#9c0006; background-color:#ffc7ce; ">Abc</td></tr><tr><td >F286</td><td >1. / Textzeichenfolge</td><td style="color:#ff0000; font-weight:bold; font-style:italic; background-color:#000000; ">Abc</td></tr><tr><td >C287</td><td >1. / Formel ist =F2:F1500="Korrektur disapproved"</td><td style="background-color:#ffff00; ">Abc</td></tr><tr><td >C287</td><td >2. / Formel ist =F2:F1500="suspected High Risk"</td><td style="background-color:#7030a0; ">Abc</td></tr><tr><td >C287</td><td >3. / Formel ist =F2:F1500="risk evaluation"</td><td style="background-color:#ff0000; ">Abc</td></tr><tr><td >C287</td><td >4. / Eindeutige Werte</td><td style="color:#9c0006; background-color:#ffc7ce; ">Abc</td></tr><tr><td >F287</td><td >1. / Textzeichenfolge</td><td style="color:#ff0000; font-weight:bold; font-style:italic; background-color:#000000; ">Abc</td></tr></table></td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel Tabellen im Web darstellen >> </span><a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de" target="_blank"> Excel Jeanie HTML 4.8 </a>
Vielen Dank für die Unterstützung
Andreas