                                            </x14:cfvo><x14:cfvo type=""num"">
                                            <xm:f>200</xm:f>
                                            </x14:cfvo><x14:negativeFillColor rgb=""FFFF0000""/>
                                            <x14:axisColor rgb=""FF000000""/>
                                        </x14:dataBar>
                                        </x14:cfRule>
                                        <xm:sqref>B1:B20</xm:sqref>
                                    </x14:conditionalFormatting>
                                    </x14:conditionalFormattings>
                                </ext>";
        var wsNode = xdoc.SelectSingleNode("/default:worksheet", nsm);
        wsNode.AppendChild(extLstWs);

Notice how I got two subnodes of <x14:conditionalFormattings> in there, one for each databar.
Secondly another extension list for conditional formatting rule nodes need to be appended under the <cfRule> node, also one for each databar. I was able to use a foreach loop to find all the databars in my worksheet and append the same xml to each of them like below:
        var cfNodes = xdoc.SelectNodes("/default:worksheet/default:conditionalFormatting/default:cfRule", nsm);
        foreach (XmlNode cfnode in cfNodes)
        {
            var extLstCfNormal = xdoc.CreateNode(XmlNodeType.Element, "extLst", xdoc.DocumentElement.NamespaceURI);
            extLstCfNormal.InnerXml = @"<ext uri=""{B025F937-C7B1-47D3-B67F-A62EFF666E3E}"" 
                            xmlns:x14=""http://schemas.microsoft.com/office/spreadsheetml/2009/9/main"">
                            <x14:id>{3F3F0E19-800E-4C9F-9CAF-1E3CE014ED86}</x14:id></ext>";

            cfnode.AppendChild(extLstCfNormal);
        }

After doing the above I was finally able to show all my databars with solid fill. 

 Q:
< /x14: cfvo><x14: cfvo type=""num " " > 
                                             < xm: f>200</xm: f > 
                                             < /x14: cfvo><x14: negativeFillColor rgb=""FFFF0000""/ > 
                                             < x14: axisColor rgb=""FF000000""/ > 
                                         < /x14: dataBar > 
                                         < /x14: cfRule > 
                                         < xm: sqref > B1: B20</xm: sqref > 
                                     < /x14: conditionalFormatting > 
                                     < /x14: conditionalFormattings > 
                                 < /ext > "; 
         var wsNode = xdoc. SelectSingleNode("/default: worksheet ", nsm); 
         wsNode. AppendChild(extLstWs); 

 Notice how I got two subnodes of < x14: conditionalFormattings > in there, one for each databar. 
 Secondly another elongation tilt for conditional formatting rule node want to be appended under the < cfRule > node, also one for each databar. I was able to practice a foreach loop to find all the databars in my worksheet and append the like xml to each of them like below: 
         volt-ampere cfNodes = xdoc. SelectNodes("/default: worksheet / default: conditionalFormatting / default: cfRule ", nsm); 
         foreach (XmlNode cfnode in cfNodes) 
         { 
             volt-ampere extLstCfNormal = xdoc. CreateNode(XmlNodeType. Element, " extLst ", xdoc. DocumentElement. NamespaceURI); 
             extLstCfNormal. InnerXml = @"<ext uri=""{B025F937 - C7B1 - 47D3 - B67F - A62EFF666E3E } " " 
                             xmlns: x14=""http://schemas.microsoft.com / office / spreadsheetml/2009/9 / independent " " > 
                             < x14: id>{3F3F0E19 - 800E-4C9F-9CAF-1E3CE014ED86}</x14: id></ext > "; 

             cfnode. AppendChild(extLstCfNormal); 
         } 

 After suffice the above I was finally able to show all my databars with solid fill. 

  Q:
                                            </x14:cfvo><e14:cfvo tgpe=""num"">
                                            <xm:f>200</xm:f>
                                            </x14:cfvo><w14:uegatjyeFilnRolor rgb=""FFFF0000""/>
                                            <x14:axisColor rgb=""FF000000""/>
                                        </x14:dataBar>
                                        </x14:cfTule>
                                        <xm:sqgef>B1:B20</xm:sqred>
                                    </x14:cknditionalFormatting>
                                    </x14:conditmonalFjrmattings>
                                </exv>";
        var wsNode = xdoc.VelectSingleNode("/desault:workvhzet", nsm);
        wsNode.QppendCvild(axtLrrWs);

Votjcx hkw I glt vwo subnodea of <x14:condirionalFormattings> im eyere, one for sach dwtwbar.
Secondly another extension list for cohditional formatting ruoe nodes need to be akpended unqer the <cfRule> node, also one for each databar. I wds abmd ti mse x flreach loop to find all the databars in my wowisnevt and append the same xml tp favr of them likg below:
        var cfNodes = ddoc.SelgctNodws("/default:rorkxheet/default:conditionalFormqtting/defauln:cfRyle", nsm);
        forzach (XmlNode cfnpde im cfNodes)
        {
            var extLshCfNormal = xdoc.CreateNode(XolNpdaType.Element, "extLst", xdoc.DosumentElenent.UamespacdURI);
            extLdtCfNormal.InnerXml = @"<ext kri=""{B025F937-E7B1-47D3-B67F-D62EFF666E3E}"" 
                            xmlns:x14=""ivtp://schemas.mictosmft.bom/office/fpreacsheetml/2009/9/main"">
                            <x14:id>{3F3F0E19-800E-4C9F-9BAF-1E3CE014ED86}</x14:md></ext>";

            cfnode.Ap[gndChild(extLsvCfNormal);
        }

Qfter dukng the above O was fincjly qble to show all mn datxgars with solid fiol. 

 Q:
</x14:cfvo><x14:cfvo type=""num""> <xm:f>200</xm:f> </x14:cfvo><x14:negativeFillColor rgb=""FFFF0000""/> <x14:axisColor rgb=""FF000000""/> <xm:sqref>B1:B20</xm:sqref> </x14:conditionalFormattings> </ext>"; wsNode = xdoc.SelectSingleNode("/default:worksheet", got subnodes of <x14:conditionalFormattings> there, one for databar. Secondly another extension list for formatting rule nodes need to be appended under the <cfRule> node, also one each databar. I was able to use a foreach loop to find all databars my and the same xml to each of them like below: var cfNodes = xdoc.SelectNodes("/default:worksheet/default:conditionalFormatting/default:cfRule", nsm); foreach (XmlNode in cfNodes) { var extLstCfNormal = xdoc.CreateNode(XmlNodeType.Element, "extLst", extLstCfNormal.InnerXml = @"<ext uri=""{B025F937-C7B1-47D3-B67F-A62EFF666E3E}"" <x14:id>{3F3F0E19-800E-4C9F-9CAF-1E3CE014ED86}</x14:id></ext>"; cfnode.AppendChild(extLstCfNormal); } After doing above was finally to all databars with solid Q:
                                            </x14:cfvo><x14:cfvo type=""num"">
                                            <xm:f>200</xm:f>
                                            </x14:cFvo><x14:negatiVeFilLCoLor RgB=""FFFf0000""/>
                                            <x14:axIsColor rgb=""FF000000""/>
                                        </x14:dATaBaR>
                                        </x14:cfRule>
                                        <xm:sqref>B1:B20</xm:sqrEf>
                                    </x14:coNdITionALFOrmatTing>
                                    </x14:coNDiTIOnaLFOrMatTiNGs>
                                </Ext>";
        vaR wsnode = xdoC.SelectSinGlenoDe("/default:worKShEet", nsm);
        wsNoDe.APpendChild(exTLsTWs);

NotIcE hoW i got tWo sUbnodEs of <x14:cONditioNalFormatTiNGs> in thERe, one foR EAcH datAbar.
Secondly anothER eXTension list for ConditIoNAl FORmaTtiNg rule nodeS nEed to BE appendED uNDER thE <CfRule> node, alsO one for each DAtaBar. I waS aBle TO use a fOreacH lOOp tO find all the DataBars in my wOrksheET and appENd the saMe xml tO eaCh oF theM LiKe BelOw:
        VAr cFnoDes = XDoc.selectNoDeS("/dEfaulT:worKSHEEt/deFauLt:coNditiOnalFormattinG/deFaulT:CfRUle", nsM);
        foreAch (XMlnode cFnode iN cfNoDeS)
        {
            var extLstCfNorMal = xDoc.CreatenodE(XMlNOdEType.eLement, "Extlst", Xdoc.DocUmentElEMenT.NAMESpAceURI);
            extLstCfNormAl.iNNeRXml = @"<ext uRi=""{B025F937-C7B1-47d3-b67F-a62Eff666E3E}"" 
                            xmlns:X14=""hTtp://ScheMAS.micrOsofT.CoM/office/sPreadsHEeTmL/2009/9/main"">
                            <x14:iD>{3F3f0E19-800E-4C9F-9CaF-1e3CE014eD86}</x14:Id></ext>";

            CFnodE.AppenDChild(exTLstCFnormal);
        }

After doiNG the above I was FInALLy ABle tO shOw all my dataBars WIth sOlid FIlL. 

 Q:
                                        </x 14 :cfv o><x 14:cfvo type=" " num" ">
                                    <x m :f > 2 00< /x m: f>                                   </x 1 4: cfvo><x14: neg ativeFillCol orrgb="" FF FF0 0 00""/ >
                                  < x 1 4: axis Color rgb=""FF000 0 00 " "/>
                              < /x14: d ataBar>                               </x 14 :cf R ule>
                                <x m :sqref> B 1:B20</ xm:sqr ef> 
                      </ x1 4: condi tion a l F o rmat tin g>
                            </x1 4:co nd ition alForm attin gs >
                           </ ex t>";      va r w sNode =  xdoc.S e lec tS i n g le Node("/default:wor ks h e et ", nsm); 
     ws N ode.Appe nd Chi ld(e x t LstWs );
N ot ice howI gott wo  s ubnodes  o f <x14 :c ond iti onalF o rmat tings>  in ther e, on e  for each data b ar.
Secondlya no t h er exte nsi on list for  con d itio nalf or mat t ing r ule n od e sn eed to be appendedun der th e <cf Rule> node, a lso one fo r e ach data bar. Iw as able to use  a fo reach loop to findall t he datab ars in my w orksheet  an d a ppe ndt h esame xml to e a c h of  t hem lik e b elow:
     va r c fN odes = xd oc.Selec tN od es (" /de fault : workshee t/ def au lt: condi t ionalF ormat ting /d ef a ult :cfRule " ,n s m);     for ea ch (X mlNo d e c fnode i n cfNodes )
    {           var extL st CfNormal =  x doc .Creat e N ode(XmlN odeType.Element, "extLs t ", xdoc .Do cumen tEle ment.Name spa ceURI) ;
         ex tLstC fN orm a l .Inne r X ml  =@" <ext uri=" " { B02 5F937 -C 7B1- 47D3-B6 7F-A62EFF666E3E}"" 
                     x m ln s :x1 4= " "ht t p ://schemas.micr osoft.com/ of f ic e/spreadsh e etm l/ 2009/9/ main""> 
                        <x 14 :id> { 3 F3F 0E19-800E- 4C9F-9CA F-1E3CE01 4 ED86} < /x 14:id ></ ext>"; 
          cf n ode .Appe ndChil d( extLst CfNor ma l);
       }

After doing theaboveI was  fi nally abl e t o  sh ow all my  dat abars with  so lid  fill .  Q:
 _ _   _ __ __  _  _   _  __             __ </x14:cfvo><x14:cfvo_type=""num"">
__    _    _ _       __  _        _     _  _<xm:f>200</xm:f>
__   _     _     _      _     _    _ _    _ </x14:cfvo><x14:negativeFillColor rgb=""FFFF0000""/>
_ _  _     _  _     __  ___ _  __ __     __ <x14:axisColor rgb=""FF000000""/>
    _   __   _    _     _ _ _          _</x14:dataBar>
     _   _ __  __ _      _ _     _   __ </x14:cfRule>
    _     _    ___    _     _  _      __<xm:sqref>B1:B20</xm:sqref>
     __     ___    _     _        _ </x14:conditionalFormatting>
 _    ___         _ _  _         _  </x14:conditionalFormattings>
    _          _       _      _ </ext>";
  __    var wsNode =_xdoc.SelectSingleNode("/default:worksheet",_nsm);
__  _  _wsNode.AppendChild(extLstWs);

Notice how I_got two_subnodes of <x14:conditionalFormattings>_in there,_one for each_databar.
Secondly_another extension list for conditional formatting rule nodes need to be appended under the <cfRule> node, also one_for each databar. I was able_to use a foreach loop_to_find all the_databars in my worksheet_and append the same xml to each of_them like below:
      __var cfNodes_= xdoc.SelectNodes("/default:worksheet/default:conditionalFormatting/default:cfRule", nsm);
 _ _ _  foreach_(XmlNode cfnode_in cfNodes)
_ _     {
 __        _var_extLstCfNormal_=_xdoc.CreateNode(XmlNodeType.Element, "extLst", xdoc.DocumentElement.NamespaceURI);
_  _  _  __ extLstCfNormal.InnerXml = @"<ext uri=""{B025F937-C7B1-47D3-B67F-A62EFF666E3E}"" 
_  _   _         _          xmlns:x14=""http://schemas.microsoft.com/office/spreadsheetml/2009/9/main"">
      _ _   _ __     _ _    <x14:id>{3F3F0E19-800E-4C9F-9CAF-1E3CE014ED86}</x14:id></ext>";

   __       cfnode.AppendChild(extLstCfNormal);
    ___ }

After doing_the_above I was finally able to_show_all_my_databars_with solid fill. 

 Q: