高頓網(wǎng)校友情提示，*7紹興會(huì)計(jì)繼續(xù)教育網(wǎng)上總結(jié)信息Excel2007新知-技巧1_色彩繽紛的Data Bars等內(nèi)容公布如下：　　Conditional Formatting Trick 1 – Multi-Coloured Data Bars
　　條件格式技巧1——色彩繽紛的Data Bars
　　A few months ago, I described the new features we have added to Excel 2007 in the area of conditional formatting. One of the new formats we added is called a “data bar” … check out this earlier post for a refresher, but the basic idea is that Excel draws a bar in each cell representing the value of that cell relative to the other cells in the selected range. Here is a shot from that post.
　　幾個(gè)月以前，我講述了在Excel 2007中  新增加的有關(guān)條件格式的各種特性，其中之一就是我們稱之為“data bar”的……可參閱以前的文章。但是我們只講到最基礎(chǔ)的概念，即在一個(gè)選定的區(qū)域里面，由Excel根據(jù)不同單元格的數(shù)值對(duì)比情況，在每個(gè)單元格中繪制一個(gè)色帶。下面是以前文章中的截圖：
　　The Excel 2007 UI allows you to choose whatever colour you want for your data bars, but, by default, all the data bars you apply to a range have to be the same colour. Someone on our team recently showed me how to use a tiny bit of VBA to simulate having multiple colours of data bars on a range conditionally applied, so I thought I would pass along the trick.
　　Excel 2007允許你為你的data bars選擇任何你想要的顏色，但是，默認(rèn)情況下，同一區(qū)域中的data bars，只能有同一種顏色。最近，開發(fā)團(tuán)隊(duì)中的某位成員向我展示了如何在同一區(qū)域中創(chuàng)建多種顏色的data bars，只需要利用非常簡單的VBA代碼即可。所以，我想我應(yīng)該好好發(fā)揮這個(gè)技巧的威力。
　　Say, for example, you are looking at student grades, and you want all the data bars for students with a passing mark (60%+ and above) to be green, and those with a failing grade (59% or less) to be red. The first thing you would do is to add some red data bars to your data, and then some green data bars. By default, Excel shows you the last set applied, so the data bars would be green. If you then launch the VB Editor (Alt + F11) and in the immediate window (Ctrl+G), type:
　　selection.FormatConditions(1).formula = "=if(c3>59, true, false)"
　　You would see that your data now looks like this, which makes it easy to spot the failing grades.
　　舉個(gè)例子，你正在考慮為學(xué)生評(píng)分，你希望當(dāng)學(xué)生成績及格（60%或更高）時(shí)，data bars是綠色的，而不合格的成績（59%或更低）對(duì)應(yīng)的data bars是紅色的。*9步，你肯定會(huì)為你的數(shù)據(jù)加上一些紅色的data bars，然后是綠色的。在默認(rèn)情況下，Excel只接受你最后的設(shè)置，所以所有的data bars都將是綠色的。如果你現(xiàn)在打開VB編輯器(Alt + F11)，在立即窗口(Ctrl+G)中輸入：selection.FormatConditions(1).formula = "=if(c3>59, true, false)"
　　你將會(huì)看到你的數(shù)據(jù)就會(huì)像下面這樣，非常容易的辨識(shí)出不合格的成績：
　　So how does this work? Every conditional format has a Formula property, which allows you to specify a formula which determines whether the conditional format is visible. In this case, we are simply saying that the green data bars (the most recent ones) should only be visible if a value is greater an 59.
　　This property is available on all conditional formats, so I expect that users will find all sorts of creative uses beyond just this case.
　　那么這項(xiàng)工作是如何完成的？原來，每一個(gè)條件格式都有一個(gè)公式的屬性，此屬性允許你指定一個(gè)公式來判斷其本身是否可見。在這個(gè)例子中，我們簡單的指定為，只有單元格數(shù)值大于59時(shí)，綠色的data bars才會(huì)被顯示。
　　所有的條件格式都可以利用這個(gè)屬性，因此，我希望用戶能夠發(fā)揮創(chuàng)造力，舉一反三。
 　　　　
　　掃一掃微信，學(xué)習(xí)實(shí)務(wù)技巧
　　　
　　高頓網(wǎng)校特別提醒：已經(jīng)報(bào)名2014年財(cái)會(huì)考試的考生可按照復(fù)習(xí)計(jì)劃有效進(jìn)行！另外，高頓網(wǎng)校2014年財(cái)會(huì)考試高清課程已經(jīng)開通，通過針對(duì)性地講解、訓(xùn)練、答疑、?？迹瑢?duì)學(xué)習(xí)過程進(jìn)行全程跟蹤、分析、指導(dǎo)，可以幫助考生全面提升備考效果。