Excel設定格式化條件:Realtime @ 2016徵求年菜推薦網路訂購最紅的商家.年菜訂購?台北年菜外送餐廳推薦(年菜)?年菜.今年不想做年菜推薦,網路宅配哪一家好?

Blogtrottr

Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 已解決

Excel設定格式化條件

Jan 28th 2015, 16:25

格式化條件-圖示集，條件規則是以單一值比較或範圍內百分比比較，公式無法以相對儲存格輸入.
因版主所求比對值為相對儲存格，所以解決辦法僅能每一個儲存格逐一輸入.
如下圖

檢視圖片檢視圖片

或者可以巨集方式，將範圍內儲存格逐一設定格式化條件.
以下僅供參考

Sub TEST2()

Dim Rng As Range
For Each Rng In Selection
rng2 = Rng.Offset(0, -1).Address
Rng.FormatConditions.AddIconSetCondition.SetFirstPriority
With Rng.FormatConditions(1)
.IconSet = ActiveWorkbook.IconSets(xl3Arrows)
.IconCriteria(2).Type = xlConditionValueNumber
.IconCriteria(2).Value = "=" & rng2
.IconCriteria(2).Operator = 7
.IconCriteria(3).Type = xlConditionValueNumber
.IconCriteria(3).Value = "=" & rng2
.IconCriteria(3).Operator = 5
End With
Next
End Sub
請參考~
https://www.dropbox.com/s/on19mc0qua8nz0h/test3.xlsb?dl=0

Recommended article: Chomsky: We Are All – Fill in the Blank.
This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions