资源描述：
《EXECL中颜色函数实战》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、EXECL中颜色函数实战Thefirstquestionisabouttheselectionofbackgroundcolors:Assumethata,B,C,andDcolumnshavedata,thefirstlineisthetitle,andtheline20,assumingthatthereiscolorintheAcolumn(becauseyouaresayingthattheentirerowisacolor)1.enterColorlinEl2.ctrl+f3,definethename,nameColorl,ande
2、nter=GET.CELL(63,Sheetl,A2),+RAND()*0inthereferencelocation(quotesnotentered)3.enter'二colorl'inE24.dragtheformulatothetwentiethline,orE205.,andthenEasthestandardfiltercan.Thesecondquestionisaboutthecolorofthefont:SimilartothefirstquestionIanswered,simplychangethereferencepos
3、itioninputto〃二GET.CELL(24,Sheetl,A2),+RAND0*o〃・Thismethodistouseareferencecolumnandmacrofunctionget.cell,canrealizethefilteringandsortingofcolordata・"GET.CELL〉GET〃means〃CELL〃，whichmeans"cell"Sometimesitmeansthatyouwanltogetwhatcell(information)Functiondefinition:GET.CELL(typ
4、enumber,cell(orrange))Thetypenumber,thatyouwanttogetthetypeofinformation,afterItestin1-66,mymotherah,thatistosayhecanreturntothe66kindsoftheinformationyouneedacell?Beforeyoudidnotthinktherearesomanykindsofinformationinacell?Thecellandrangedoesn，tmeananythingGoodaccesstoactua
5、lcombat!Note:thisfunctioncannotbereferenceddirectlyinacel1.Thatis,itcannotbewrittendirectlyintheeditbar・Ican，twriteitintheformula.Whatelsedoesthisfunctiondo?HEHE,themasterisoverhere,notwrittenintheformula,butwecanwriteitinthename!!Forexample,nowwe'regoingtogetthedataformatin
6、theAlcel1.TheresultisshownintheBlstepasfollows:1.chooseacelltoinserthisname——>——>definition2.inthename,enterAA(anyname)3.write二GET.CELL(7,Sheetl,$A$1)onthereferencelocationAdd4.points1.enter二AAintheBlcellYes,whatdoesitshow?Ifithasn，tbeenmodified,itshouldbeintheG/generalforma
7、t!Thefollowingisthetypenumberandthemeaningoftherepresentative1refertotheabsoluteaddressofthestoragecell2refertothecolumnnumberofthestoragecell3refertothecolumnnumberofthestoragegrid4similartotheTYPEfunction5refertothecontentsoftheaddress6textdisplayreferenceaddressformula7re
8、ferenceaddressformat,textdisplay8textdisplayreferenceaddressformat9returnst
