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

¨D§U¡G¤µ¤é©Î¤µ¤é¤§«eªº¤é´Á,¦rÅéÅܦâ

¨D§U¡G¤µ¤é©Î¤µ¤é¤§«eªº¤é´Á,¦rÅéÅܦâ

¦]¿é¤J¸ê®Æ®É
»Ý­n¿é¤J¤j¶q¤é´Á(Àx¦s®æ¿W¥ß©ñ¸m¤@­Ó¤é´Á)
®e©ö±N¦~¥÷¿é¤J¿ù»~(¨Ò:7/8/2016¿ù»~¥´¦¨7/8/2014)
¿ù»~³y¦¨¸Ó¶µ¸ê®Æ¹L®É

·Q°Ý°Ý¦³¨S¦³¤èªk¿é¤J¤é´Á¸ê®Æ®É
·í¤é´Á¿é¤J®É¬O¤µ¤Ñ©Î¤µ¤Ñ¤§«e
¦rÅé·|Åܦ¨¥t¤@ºØÃC¦â(¨Ò¦p:¬õ¦â)

¦^´_ 1# K_Wing

Fig.jpg (70.06 KB)

Fig.jpg

TOP

¦^´_ 2# p212
·PÁÂ¥S§ÌÀ°¦£
¡y±ø¥ó®æ¦¡¤Æ¡z¦¹¤èªk¤w¸Õ¹L
¥u¯à³W­­¤µ¤Ñ©M¬Q¤Ñ
Àx¦s®æªº¤é´Á¤~·|Åܦâ
¦ý­YµM¦A¦­¤@¨Ç¤é¤l
¤é´ÁÓý¨S¦³Âà¦â

§Ú·Q­nªº¬O¡G¤µ¤é¤S©Î¤µ¤é¤§«eªº¤é´Á·|Åܦâ

TOP

DEAR SIR
  ¡y±ø¥ó®æ¦¡¤Æ¡z¸Õ¸Õ§ï¤½¦¡
=IF(C4-NOW()<=0,TRUE,FALSE)
ù

TOP

DEAR SIR
  ¡y±ø¥ó®æ¦¡¤Æ¡z¸Õ¸Õ§ï¤½¦¡
=IF(C4-NOW()<=0,TRUE,FALSE)
rouber590324 µoªí©ó 2014-12-15 16:29

¦hÁÂ¥S§Ì©Þ¤M¬Û§U
¤w¹Á¸Õ¹L¦b¡y±ø¥ó®æ¦¡¤Æ¡z¥[¤J¦¹¤½¦¡
±o¥Xªºµª®×¬O
µL½×¤µ¤é¤§«e©Î«á
¤é´Á³£·|Åܦâ

¥t·Q°Ý°Ý¤½¦¡¤¤ªº"C4"¬O¥Nªí¬Æ»ò?

TOP

¦^´_ 5# K_Wing


    C4  => Àx¦s®æ CÄæ²Ä4¦C
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

¦^´_ 5# K_Wing

     ¦¹¼gªk°w¹ïA5³o­ÓÄæ¦ìªº¤é´Á¥h¸ò²{¦bªº®É¶¡¤ñ¸û~ ¦Ó§ïÅÜÃC¦â~
     ¥i¥H¡A¸Õ°µ¬Ý¬Ý~
  1. Private Sub Worksheet_Change(ByVal Target As Range)

  2. If Target = Range("A5") And Range("A5") < Now() Then
  3.     Range("A5").Interior.ColorIndex = 3
  4. End If

  5. End Sub
½Æ»s¥N½X
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

¥»©«³Ì«á¥Ñ K_Wing ©ó 2014-12-15 20:39 ½s¿è

¦^´_ 7# hugh0620
:L
ǢǢ...
§Ú³o­Ó¤p¾Ç¥Í
»¡¥X¨Ó¹ê¦b¦½ÃC
»yªkÁÙ¤£À´©ñ¨ì¨º¸Ì¨Ï¥Î...
¤£¹LÁÙ¬O­n¦hÁÂ¥S§ÌÀ°¦£

TOP

¥»©«³Ì«á¥Ñ hugh0620 ©ó 2014-12-16 00:18 ½s¿è

¦^´_ 8# K_Wing

¥i¥H¶}¤@­Ó·sÀÉ®×´ú¸Õ

Excel 2007ªº¸Ü~ ¥ý¨ì¤@¯ë->¶}µo¤H­û¤Ä¿ï°_¨Ó~  ´N¦³¿ï¶µ¥i¥HÅý§A¶}±ÒVBªºµ{¦¡¼¶¼g°Ï
(²{¦b§Ú¬O¥Î2013~ ©Ò¥H¦³ÂI§Ñ°O2007VB¶}±Òªº¤è¦¡~ ¦³»~ªº¸Ü~ ½Ð¨£½Ì)

¥i¥H°Ñ·Ó¤U­±¹Ï¤ù©Î¬Oª¦ª¦¤å´Nª¾¹D¤F~                                                   

¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

1. =IF(AND(A1-NOW()<=0,A1<>""),TRUE,FALSE)
1.1 A1  => Àx¦s®æ²Ä1Äæ²Ä1¦C
2.§A±N·ÆÄݲ¾©óA1ÀxÀx¦s®æ.µM«á ®æ¦¡-³]©w®æ¦¡¤Æ±ø¥ó-¤½¦¡¬°
  2.1  COPY =IF(AND(A1-NOW()<=0,A1<>""),TRUE,FALSE)
2.2  ­nÅܤ§¦r§Î/¥~¦J/ÃC¦â ¤º®e»Ý¦Û¦æ¿ï¨ú(µL¿ï¨ú¤£·|Åܦâ)
3.©ó A1 ¿é¤J 12/16¤§«e·|¨ÌITEM2.2§A·Q­n¤§»Ý¨DÅܦâ.
4.¦A¸Õ¸Õ.
ù

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD