Excel設定格式化條件:Realtime－進擊的巨人14, 進擊的巨人線上看, 進擊的巨人漫畫, 進擊的巨人遊戲, 進擊的巨人動畫, 進擊的巨人線上漫畫, 進擊的巨人14線上看, 進擊的巨人13, 進擊的巨人 h, 進擊的巨人op

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