ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¨Ì¾ÚÃC¦â§PÂ_°ÝÃD

[µo°Ý] ¨Ì¾ÚÃC¦â§PÂ_°ÝÃD

¤j®a¦n:

     ·Q°Ý¤@¤U¡F§Ú­n¦p¦ó§Q¥Î²Ä¤@ÄæÅã¥Ü"¾ï¦â"¤Î²Ä¤GÄæÅã¥Ü"¶À¦â"ªº±ø¥ó¤U¡F¦b²Ä¤TÄæ«ü©wÃC¦â¬°¬õ¦â©O?
     ¦]±ø¥ó§PÂ_¬OÃC¦â¡A¨S§Q¥ÎÃC¦â·í§@§PÂ_¨Ï¥Î¹L¡A¤£ª¾¹D«ç»ò¼g§PÂ_¦¡¡C
     Àµ½Ð«ü±Ð¡AÁÂÁ¡C

test.rar (32.16 KB)

¦^´_ 1# spermbank
  1. Sub ex()
  2. Dim A As Range
  3. For Each A In Range([A1], [A1].End(xlDown))
  4.   If A.Interior.ColorIndex = 44 And A.Offset(, 1).Interior.ColorIndex = 6 Then _
  5.   A.Offset(, 2).Interior.ColorIndex = 3 Else A.Offset(, 2).Interior.ColorIndex = -4142
  6. Next
  7. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


    ÁÂÁ¤j¤j

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD