Cell cika da darajar a Microsoft Excel

Lokacin aiki tare da tebur, dabi'un da aka nuna a ciki suna da mahimmancin gaske. Amma muhimmin sashi shima tsarin sa ne. Wasu masu amfani suna ɗaukar wannan a matsayin sakandare kuma basa kula sosai. Amma a banza, saboda tebur da aka tsara da kyau kyakkyawan yanayi ne don kyakkyawan hasashe da fahimta ta hanyar masu amfani. Matsayi na musamman yana taka muhimmiyar rawa ta hanyar hangen nesa. Misali, ta amfani da kayan aikin hangen nesa, zaku iya amfani da sel na tebur masu launi dangane da abinda suke ciki. Bari mu bincika yadda za a iya yin wannan a Excel.

Hanyar canza launi ta sel dangane da abun ciki

Tabbas, yana da kyau koyaushe a sami tebur da aka tsara a ciki wanda sel, dangane da abin da ke ciki, ana fentin su cikin launuka daban-daban. Amma wannan fasalin yana dacewa musamman ga manyan tebur waɗanda ke ɗauke da mahimman bayanai. A wannan yanayin, cike sel da launi zai iya sauƙaƙe manufar masu amfani a cikin wannan babban adadin bayanai, kamar yadda za'a iya cewa an riga an tsara shi.

Kuna iya ƙoƙarin canza launin abubuwa da hannu, amma kuma, idan tebur ɗin ya yi girma, zai ɗauki lokaci mai yawa. Bugu da kari, a cikin irin wannan tsari, bayanan mutum zai iya taka rawa kuma za a yi kurakurai. Ba tare da ambaton cewa teburin na iya zama mai fa'ida ba kuma bayanan da ke ciki lokaci-lokaci suna canzawa, kuma suna da yawa. A wannan yanayin, canza launi da hannu gaba ɗaya ya zama mara fahimta.

Amma akwai wata hanyar fita. Don sel waɗanda ke ɗauke da ƙima (canzawa) dabi'u, ana amfani da tsarin kwaskwarima, kuma don ƙididdiga za ku iya amfani da kayan aikin Nemo ka Sauya.

Hanyar 1: Tsarin Yanayi

Yin amfani da tsari na al'ada, zaku iya fayyace wasu iyakokin dabi'u waɗanda za'a fentin sel a launi ɗaya ko wata. Za'a aiwatar da rufe kai tsaye. Idan ƙimar tantanin halitta, saboda canji, ya ƙetare kan iyaka, to wannan kayan aikin za'a gyara shi ta atomatik.

Bari mu ga yadda wannan hanya take aiki akan takamaiman misali. Muna da teburin samun kuɗin shiga wanda a cikin muke watsar da bayanan kowane wata. Muna buƙatar nuna alama a cikin launuka daban-daban waɗancan abubuwan waɗanda ƙimar kuɗi ke ƙasa 400000 rubles, daga 400000 a da 500000 rubles da ƙari 500000 rubles.

1. Zaɓi shafi wanda bayani game da kudin shiga na kamfanin yake. Sannan mun matsa zuwa shafin "Gida". Latsa maballin Tsarin Yanayiwacce take akan kintinkiri a cikin akwatin kayan aiki Salo. Cikin jeri dake buɗe, zaɓi "Gudanar da ka'idoji ...".



2. Takobin don gudanar da ka'idojin tsara ka'idojin yanayin yana farawa. A fagen "Nuna ka'idodin tsara bayanai don" dole ne a saita zuwa "Currentangare Na Yanzu". Ta hanyar tsoho, yakamata a nuna a wurin, amma kawai idan, bincika kuma idan akwai rashin biyayya ta canza saiti bisa ga shawarwarin da aka bayar a sama. Bayan haka, danna maɓallin "Airƙiri doka ...".



3. Tagan don ƙirƙirar tsarin tsarawa yana buɗe. A cikin jerin nau'in mulkin, zaɓi matsayin "Haɗi kawai sel waɗanda suke ɗauke da". A cikin bayanin bayanin dokar a farkon zangon, mai sauyawa ya kamata ya kasance cikin matsayi "Dabi'u". A cikin na biyu filin, saita sauya zuwa Kadan. A cikin na uku filin, saka darajar, abubuwa masu dauke da darajar ƙasa da abin da za a fentin a wani launi. A cikin lamarinmu, wannan darajar zata kasance 400000. Bayan haka, danna maɓallin "Tsarin ...".



4. Tayin wayar salula yana buɗewa. Matsa zuwa shafin "Cika". Zabi launi mai cika wanda muke son sel da ƙasa da 400000. Bayan haka, danna maɓallin "Ok" a kasan taga.



5. Mun koma zuwa taga don ƙirƙirar tsarin tsarawa kuma a can, ma, danna maɓallin "Ok".



6. Bayan wannan aikin, za a sake tura mu zuwa Tsarin Dokar Ka'idojin Yanayi. Kamar yadda kake gani, an riga an ƙara doka guda ɗaya, amma dole ne mu ƙara ƙarin. Don haka sake danna maballin "Airƙiri doka ...".



7. Kuma mun sake shiga taga halittar doka. Mun matsa zuwa sashin "Haɗi kawai sel waɗanda suke ɗauke da". A farkon filin wannan sashin, bar sigogi "Darajar tantanin halitta", kuma a cikin na biyu mun saita canji zuwa matsayi Tsakanin. A cikin filin na uku, saka ƙimar farko na kewayon abin da za'a tsara abubuwan bayanan. A cikin lamarinmu, wannan lambar 400000. A na huɗun, muna nuna darajar ƙarshe ta wannan kewayon. Zai yi 500000. Bayan haka, danna maɓallin "Tsarin ...".



8. A cikin taga tsara, mun sake matsawa zuwa shafin "Cika", amma wannan lokacin tuni mun zabi wani launi daban, sannan kuma danna maballin "Ok".



9. Bayan dawowa taga taga mulkin, shima danna maballin "Ok".



10. Kamar yadda muke gani, a ciki Manajan mulki Mun riga mun tsara dokoki biyu. Don haka, ya wanzu don ƙirƙirar na uku. Latsa maballin Createirƙiri mulki.



11. A cikin taga halittar, mun sake matsawa zuwa sashin "Haɗi kawai sel waɗanda suke ɗauke da". A farkon filin, barin zaɓi "Darajar tantanin halitta". A cikin na biyu filin, saita ma sauya zuwa ga 'yan sanda .Ari. A cikin na uku da muke tuki da lamba 500000. To, kamar yadda ya gabata, danna maɓallin "Tsarin ...".



12. A cikin taga Tsarin Cell sake matsawa zuwa shafin "Cika". Wannan lokacin zabi launi wanda ya bambanta da lokuta biyu da suka gabata. Latsa maballin. "Ok".



13. A cikin taga don ƙirƙirar dokoki, maimaita danna maɓallin "Ok".



14. Yana buɗewa Manajan mulki. Kamar yadda kake gani, an tsara dukkanin dokoki uku, don haka danna maballin "Ok".



15. Yanzu abubuwan tebur suna canza launin bisa ga yanayin da aka ƙayyade da iyaka a cikin saitunan tsara yanayin.



16. Idan muka canza abubuwan cikin ɗayan sel, yayin da muke wuce iyakokin ɗaya daga cikin ƙayyadaddun ƙa'idodi, to, wannan samfurin zai canza launin ta atomatik.

Kari akan haka, zaku iya amfani da Tsarin yanayi a wata madaidaiciyar hanya don abubuwa masu launi.

1. Saboda wannan bayan fitar Manajan mulki mun je taga tsara bayanai, sannan mu ci gaba da zama a sashen "Ka tsara dukkan kwayoyin halitta bisa ka'idodin su". A fagen "Launi" zaku iya zabar launi, inuwa wacce zata cika abubuwan da ke cikin takardar. Sannan danna maballin "Ok".



2. A Manajan mulki kuma danna maballin "Ok".



3. Kamar yadda kake gani, bayan wannan an zana sel a cikin akwati tare da tabarau daban-daban na launi iri ɗaya. Largerimar da ta fi girma wacce ke ƙunshe da ƙarin takardar, ƙarin inuwa ya fi sauƙi, ƙasa kaɗan - duhu.

Darasi: Tsarin yanayi a cikin Excel

Hanyar 2: yi amfani da kayan bincike da Zaɓi

Idan teburin ya ƙunshi bayanan ƙirar da ba a shirya canzawa na lokaci ba, to, zaku iya amfani da kayan aikin don canza launi na sel ta abubuwan da ke ciki a ƙarƙashin sunan Nemo da Haskaka. Kayan aiki da aka ƙayyade zai ba ka damar nemo ƙimar da aka ƙayyade kuma canza launi a cikin waɗannan ƙwayoyin zuwa mai amfani da ake so. Amma ya kamata a sani cewa lokacin da abun ciki a cikin abubuwan takardar ya canza, launi ba zai canza ta atomatik ba, amma zai kasance iri ɗaya. Domin sauya launi zuwa wanda yake a yanzu, zaku sake maimaita hanyar. Sabili da haka, wannan hanyar ba mafi kyau bace ga tebur tare da abun ciki mai tsauri.

Za mu ga yadda wannan ke aiki akan ingantaccen misali, wanda muke ɗaukar tebur ɗaya na kuɗin shiga.

1. Zaɓi shafi tare da bayanan da za'a tsara tare da launi. To tafi zuwa shafin "Gida" kuma danna maballin Nemo da Haskaka, wanda aka sanya a kan tef a cikin toshe kayan aiki "Gyara". A cikin jerin da ke buɗe, danna kan kayan Nemo.



2. Window yana farawa Nemo ka Sauya a cikin shafin Nemo. Da farko dai, gano dabi'u har 400000 rubles. Tunda ba mu da sel guda da ya ƙunshi ƙasa da 300000 rubles, to, a gaskiya, muna buƙatar zaɓar duk abubuwan da suke ɗauke da lambobi a cikin kewayon daga 300000 a da 400000. Abin takaici, ba zaku iya tantance wannan kewayan kai tsaye ba, kamar yadda akan yanayin tsara yanayin, a wannan hanyar.

   Amma akwai damar yin wani abu daban, wanda zai ba mu sakamako iri ɗaya. Kuna iya tantance hanyar da ke biye a cikin mashaya binciken "3?????". Alamar tambaya tana nufin kowane halayya. Don haka, shirin zai bincika duk lambobin lambobi shida waɗanda suka fara da lambar "3". Wannan shine, dabi'u a cikin kewayon sun faɗi cikin sakamakon bincike 300000 - 400000, wanda shine abin da muke buƙata. Idan teburin yana da lambobi ƙasa 300000 ko .asa da 200000, sannan ga kowane kewayon dubu ɗari, ana buƙatar ayi binciken daban.

   Shigar da magana "3?????" a fagen Nemo kuma danna maballin "Nemo duka".



3. Bayan wannan, ana buɗe sakamakon binciken a cikin ɓangaren ƙananan taga. Hagu-danna kan kowane ɗayansu. Sannan mu buga hade makullin Ctrl + A. Bayan haka, dukkanin abubuwan bincike suna nuna alama kuma a lokaci guda abubuwan da ke cikin shafi wanda waɗannan sakamakon ke nuni suna nuna alama.



4. Bayan an zaɓi abubuwan da ke cikin shafi, ba mu cikin sauri don rufe taga Nemo ka Sauya. Kasancewa a cikin shafin "Gida" a cikin abin da muka motsa a baya, je zuwa tef ɗin zuwa toshe kayan aiki Harafi. Danna kan alwatika na dama daga maɓallin Cika Launi. Zaɓin launuka daban-daban na buɗe. Zaɓi launi da muke so mu shafa wa abubuwan kayan ginin da ke ƙasa da 400000 rubles.



5. Kamar yadda kake gani, duk sel a cikin sashin da dabi'un su kasa da 400000 rubles alama a cikin launi da aka zaɓa.



6. Yanzu muna buƙatar canza launin abubuwan da dabi'u suke daga 400000 a da 500000 rubles. Wannan kewayon ya hada da lambobin da suka dace da tsarin. "4??????". Fitar da shi cikin filin bincike sannan danna maballin Nemo Dukda farko zabar shafi da muke buƙata.



7. Hakanan, tare da lokacin da ya gabata a sakamakon binciken, muna zaɓar duk sakamakon da aka samu ta latsa haɗin hotkey Ctrl + A. Bayan haka, matsa zuwa gunkin zabin launi. Mun danna shi kuma danna kan maballin inuwa da ake so wanda zai canza launuka na takardar, inda dabi'u suke a cikin kewayon daga 400000 a da 500000.



8. Kamar yadda kake gani, bayan wannan matakin duk abubuwan da ke cikin tebur tare da bayanai a cikin tazara daga 400000 ta 500000 alama a launi da aka zaɓa.



9. Yanzu muna buƙatar zaɓar tazara ta ƙarshe - mafi 500000. Anan ne muke kuma masu sa'a, tunda duk lambobin sun fi yawa 500000 suna cikin kewayon daga 500000 a da 600000. Sabili da haka, a cikin filin bincike, shigar da magana "5?????" kuma danna maballin Nemo Duk. Idan da akwai dabi'u da yawa 600000, sannan ya zama dole mu nemi karin magana "6?????" da sauransu



10. Sake maimaita sakamakon binciken ta amfani da hade Ctrl + A. Na gaba, ta amfani da maballin a kintinkiri, zaɓi sabon launi don cike tazara ta wuce 500000 da wannan misalin kamar yadda muka yi a baya.



11. Kamar yadda kake gani, bayan wannan matakin za a fentin dukkanin abubuwan da ke cikin shafi, gwargwadon lambar lambobi da aka sanya su a ciki. Yanzu zaku iya rufe taga bincika ta danna daidaitaccen maɓallin kewayawa a saman kusurwar dama ta window, tunda ana iya ɗaukar aikin mu.



12. Amma idan muka maye gurbin lambar tare da wani wanda ya wuce iyakokin da aka saita don wani launi, to launi ba zai canza ba, kamar yadda yake a cikin hanyar da ta gabata. Wannan yana nuna cewa wannan zaɓi zaiyi aiki da dogaro kawai a cikin waɗancan teburin waɗanda bayanan ba ya canzawa.

Darasi: Yadda ake yin bincike a Excel

Kamar yadda kake gani, akwai hanyoyi guda biyu don canza launuka masu launi dangane da ƙimar lambobi waɗanda suke cikinsu: ta amfani da tsara yanayin da amfani da kayan aiki Nemo ka Sauya. Hanya ta farko tana da haɓaka, tunda tana ba ku damar saita yanayi ta hanyar abin da za'a inganta abubuwan da ke cikin shafin. Bugu da ƙari, tare da tsari na al'ada, launin kashi yana canza ta atomatik idan abubuwan da ke ciki ya canza, wanda hanyar ta biyu ba zata iya yi ba. Koyaya, cike sel ta dogara da ƙimar ta hanyar amfani da kayan aiki Nemo ka Sauya Haka ma, wannan zai iya yiwuwa a yi amfani da, amma a cikin a tsaye tebur.