Excel:使用条件格式根据单元格内容控制一行的背景颜色

2015年03月16日 其他资源 11条评论 阅读12246次

Excel:使用条件格式根据单元格内容控制一行的背景颜色

excel-jileniao.net.jpg

以前经常用的一个功能,好久不用就要忘记了。写下来做记录。

最近在win7上用git下载android5的源代码,直接从https://android.googlesource.com上下载的,因网站上是分模块给出的git库地址,所以在下载的时候也要单独按照git库分模块下载了。

总共772个git库资源,为方便管理,我把这些所有的git资源库地址放在了excel中来标记各资源库的当前下载状况。

在Excel中,如果一个git资源库下载完成,则在该行一个单元格中标记OK,若有下载失败的情况,则标记NG。

为了更加明显的看到NG的项目,我要筛选NG的数据,当然用数据筛选也可以做到,但我还是想要一行背景变为醒目颜色的方法。

具体方法记录如下:

选择Excel的A1单元格

在excel的开始Tab中,选择“条件格式”

点击管理规则

点击新建规则

选择使用公式确定要设置格式的单元格

下面公式编辑框中输入=$A1="NG"

右侧格式按钮点击后选择一个要设置的样式

上面的操作完成并点击了确定后,在“条件格式规则管理器”对话框中”对话框中,设置应用于的框中输入=$1:$65536

点击确定.

应该到此就完成了。

注意事项:

条件公式编辑时记得要是$A1,而不要写$A$1

分享本文至:

WRITTEN BY

avatar
本文标签:excel
看了本文是不是觉得很赞,那就赶紧点击下面按钮分享给身边的朋友吧!

11 条评论

  1. avatar getbizbuilder

    <a href="http://www.tumblrwiz.com/roshe-run-hyp-prm-qs-gull-scarpea">roshe run hyp prm qs gull</a> <a href="http://www.usafitno.com/adidas-harden-vol-1-orange-marron-scarpef">adidas harden vol 1 orange marron</a> <a href="http://www.corewmi.com/air-max-2016-l%C3%A6der-bl%C3%A5-gr%C3%B8n-sort-hvid-obuvd">air max 2016 l忙der bl氓 gr酶n sort hvid</a> <a href="http://www.faimark.com/air-jordan-retro-9-kvinners-mint-gr%C3%B8nn-gul-scarpea">air jordan retro 9 kvinners mint gr酶nn gul</a> <a href="http://www.madamevelvet.com/kobe-6-fade-to-negro-for-venta-chaussuresg">kobe 6 fade to negro for venta</a> <a href="http://www.moveinplace.com/nike-mercurial-superfly-lilla-gul-kurpesf">nike mercurial superfly lilla gul</a>
    getbizbuilder http://www.getbizbuilder.com/

  2. avatar kotakapps

    <a href="http://www.hungrygatorpr.com/asics-gel-lyte-v-5-sko-koyo-burgundy-dark-gr%C3%A5-gr%C3%B8nn-kurpesd">asics gel lyte v 5 sko koyo burgundy dark gr氓 gr酶nn</a> <a href="http://www.jonvietor.com/germany-blank-army-green-goalkeeper-soccer-country-jersey-nflz">germany blank army green goalkeeper soccer country jersey</a> <a href="http://www.mbejobs.com/nike-air-max-95-gituttio-grigio-oil-obuve">nike air max 95 gituttio grigio oil</a> <a href="http://www.refoodle.com/zx-flux-viola-haze-scarped">zx flux viola haze</a> <a href="http://www.toilocadeau.com/nike-w-internationalist-premium-blanc-kurpesc">nike w internationalist premium blanc</a> <a href="http://www.wlstoday.com/nike-super-bowl-lii-womens-malcom-brown-limited-navy-blue-home-jersey-new-england-patriots-nfl-90-vapor-untouchable-nflr">nike super bowl lii womens malcom brown limited navy blue home jersey new england patriots nfl 90 vapor untouchable</a>
    kotakapps http://www.kotakapps.com/

  3. avatar ioioland

    <a href="http://www.swnblog.com/nike-free-rn-red-up-sneakere">nike free rn red up</a> <a href="http://www.weimpactmds.com/nike-flyknit-racer-lagoon-blau-xm%C3%A4nner-kurpesa">nike flyknit racer lagoon blau xm盲nner</a> <a href="http://www.relsflorida.com/kd-8-green-new-sneakerb">kd 8 green new</a> <a href="http://www.votuongluan.com/nike-lebron-13-low-team-red-line-shoesg">nike lebron 13 low team red line</a> <a href="http://www.hanayaflowers.com/chicago-blackhawks-bucket-hat-hats">chicago blackhawks bucket hat</a> <a href="http://www.jlchatlaw.com/nike-air-max-90-vt-pink-blue-sneakerf">nike air max 90 vt pink blue</a>
    ioioland http://www.ioioland.com/

  4. avatar buditrek

    <a href="http://www.hitsturbines.com/adidas-forum-mid-for-vendita-list-kurpesg">adidas forum mid for vendita list</a> <a href="http://www.jadamsrealtor.com/nike-air-jordan-1-retro-high-og-sort-soft-gr%C3%A5-obuvb">nike air jordan 1 retro high og sort soft gr氓</a> <a href="http://www.karenconti.com/lebron-13-noir-lion-man-butya">lebron 13 noir lion man</a> <a href="http://www.cliffsears.com/san-francisco-giants-alternate-jersey-nflu">san francisco giants alternate jersey</a> <a href="http://www.rfsloan.com/nike-roshe-run-enfants-marron-noir-kurpesb">nike roshe run enfants marron noir</a> <a href="http://www.gfwholesalers.com/nike-air-max-tn-wei%C3%9F-schwarz-kind-schuhec">nike air max tn wei脽 schwarz kind</a>
    buditrek http://www.buditrek.com/

  5. avatar dealdragonads

    <a href="http://www.epackproject.com/air-jordan-5-wei%C3%9F-cem%C3%A4nnert-2017-jewels-chaussuresa">air jordan 5 wei脽 cem盲nnert 2017 jewels</a> <a href="http://www.flashuse.com/adidas-pr%C3%B8dator-instinct-svart-hvit-butya">adidas pr酶dator instinct svart hvit</a> <a href="http://www.airtestuser.com/air-jordan-1-grigio-rosso-scarpef">air jordan 1 grigio rosso</a> <a href="http://www.bajigour.com/nike-kd-8-gituttio-grigio-butyf">nike kd 8 gituttio grigio</a> <a href="http://www.calaforracs.com/adidas-zx-900-gr%C3%B8n-himmelbl%C3%A5-butyf">adidas zx 900 gr酶n himmelbl氓</a> <a href="http://www.clboaiyy.com/nike-roshe-run-kvinders-lyser%C3%B8d-schuhea">nike roshe run kvinders lyser酶d</a>
    dealdragonads http://www.dealdragonads.com/

  6. avatar yvutube

    <a href="http://www.brutalistmap.com/mens-north-face-down-jacket-clearance-northfacec">mens north face down jacket clearance</a> <a href="http://www.paulawooley.com/prada-quilted-nylon-bag-pradar">prada quilted nylon bag</a> <a href="http://www.hagertools.com/nike-air-zoom-pegasus-32-black-black-skos">nike air zoom pegasus 32 black black</a> <a href="http://www.signalsvideo.com/mlb-jerseys-san-diego-padres-44-jake-peavy-home-white-jerseys-nfld">mlb jerseys san diego padres 44 jake peavy home white jerseys</a> <a href="http://www.blainefxb.com/bon-march%C3%A9-nike-air-force-1-flyknit-high-hommes-argent-skod">bon march茅 nike air force 1 flyknit high hommes argent</a> <a href="http://www.linamauri.com/burberry-check-print-silk-scarf-scarfr">burberry check print silk scarf</a>
    yvutube http://www.yvutube.com/

  7. avatar buscochef

    <a href="http://www.johngerretsen.com/adidas-stan-smith-velcro-white-green-skos">adidas stan smith velcro white green</a> <a href="http://www.cigarlogbook.com/new-york-yankees-12-chase-headley-navy-blue-alternate-mlb-jersey-nflb">new york yankees 12 chase headley navy blue alternate mlb jersey</a> <a href="http://www.verylatebay.com/nike-mercurial-superfly-leather-ag-r-firm-ground-soccer-cleats-skoe">nike mercurial superfly leather ag r firm ground soccer cleats</a> <a href="http://www.visasdecanada.com/hermes-twilly-scarf-scarfr">hermes twilly scarf</a> <a href="http://www.dulcemusa.com/bon-march%C3%A9-nike-free-tr-fit-hommes-blanc-sneakerb">bon march茅 nike free tr fit hommes blanc</a> <a href="http://www.gypsandco.com/nike-zoom-structure-18-mens-grey-shoesd">nike zoom structure 18 mens grey</a>
    buscochef http://www.buscochef.com/

  8. avatar naijareward

    <a href="http://www.wensemble.com/canada-goose-vest-mens-canadagooser">canada goose vest mens</a> <a href="http://www.offertborsen.com/burberry-scarf-etsy-womens-scarfc">burberry scarf etsy womens</a> <a href="http://www.checkmyvape.com/prada-hibiscus-backpack-2017-pradaf">prada hibiscus backpack 2017</a> <a href="http://www.pilaminates.com/t%C3%AAnis-adidas-springblade-drive-skor">t锚nis adidas springblade drive</a> <a href="http://www.tracithrasher.com/gianmarco-lorenzi-over-the-knee-boots-louboutinr">gianmarco lorenzi over the knee boots</a> <a href="http://www.visapuebla.com/mens-nike-air-max-2015-black-and-white-skor">mens nike air max 2015 black and white</a>
    [url=http://www.naijareward.com/]naijareward[/url]

  9. avatar alannacaldas

    <a href="http://www.juraamei.com/bon-march%C3%A9-nike-roshe-run-high-femmes-or-shoesa">bon march茅 nike roshe run high femmes or</a> <a href="http://www.beoshoes.com/nike-mercurial-vapor-superfly-1-skos">nike mercurial vapor superfly 1</a> <a href="http://www.samuelzide.com/ferragamo-belt-colors-beltr">ferragamo belt colors</a> <a href="http://www.zealouslyzika.com/mackage-handbag-blog-da-mackagea">mackage handbag blog da</a> <a href="http://www.tjharkins.com/new-balance-998-eastbay-skow">new balance 998 eastbay</a> <a href="http://www.bringussocial.com/colorado-avalanche-92-gabriel-landeskog-blue-third-jersey-nflg">colorado avalanche 92 gabriel landeskog blue third jersey</a>
    alannacaldas http://www.alannacaldas.com/

  10. avatar 肖振杰博客

    EXCEL很少用到。

欢迎留言




用户登录

sitemap