批踢踢實業坊 ask 板: [請問] excel 日期問題－

Blogtrottr

批踢踢實業坊 ask 板

[請問] excel 日期問題

Apr 8th 2014, 19:54, by haoamou

作者haoamou ((1233211234567))

看板ask

標題[請問] excel 日期問題

時間Tue Apr 8 19:54:48 2014

各位先進好想請教假設我在EXCEL的橫向輸入日期比如說 2/1 2/2 2/3 .... 那我可以設定在直向輸入日期區間 (2/1~2/8) 那此區間自動標註為紅色可否設定成這樣我敘述比較差 http://ppt.cc/bytF 是上圖的概念謝謝各位 -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 114.37.30.191 ※ 文章網址: http://www.ptt.cc/bbs/ask/M.1396958091.A.3B7.html

→ wxtab019:稍微看了一下如果是這種格式感覺要用VBA寫 04/08 20:06

→ wxtab019:if不知道能不能拆出儲存格的特定字元 04/08 20:06

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