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

½Ð°ÝVBA»s§@¥|¯Z¤G½ü¯Zªí°ÝÃD

½Ð°ÝVBA»s§@¥|¯Z¤G½ü¯Zªí°ÝÃD

½Ð°Ý¦pªG­n¦p¦P¹Ï¥Ü¡A¤G¤Ñ©³¦â­n¤£¤@¼Ë¡A¸Ó¦p¦ó¼g©O¡AÁÂÁ¦U¦ì

¦^´_ 4# Muffledsatyr


    Àx¦s®æªº³]©w®æ¦¡¤Æ±ø¥ó - ¨Ï¥Î¤½¦¡¨Ó³]©w®æ¦¡¤Æ

¤£¦n·N«ä!!§Ú¬Ý¤£À´³o¬O¤°»ò·N«ä?
®æ¦¡¤Æ (²Ä¤G¦æ¦rÅé¦Ç¦â) C2:I2=C2>15

ªí¥Ü¿ï¾Ü C2:I2 Àx¦s®æªº³]©w®æ¦¡¤Æ±ø¥ó¡A¿é¤J¤½¦¡ =C2>15¡A¦A¿ï¾Ü¦rÅ鬰¦Ç¦â
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

­ø¡A¬°¤°»ò§Ú¬d¨ìªº½s¸¹¬O6436©O?
https://blog.xuite.net/hcm19522/twblog/588775126
¤£¹LÁÂÁÂH¤j¸Ñ¨M§Ú ...
lin0902 µoªí©ó 2020-8-30 23:22



    ¤£¦n·N«ä!!§Ú¬Ý¤£À´³o¬O¤°»ò·N«ä?
®æ¦¡¤Æ (²Ä¤G¦æ¦rÅé¦Ç¦â) C2:I2=C2>15

®æ¦¡¤Æ (²Ä¤­¤»¦æ¦rÅé¦Ç¦â) C6:I7=C6<15

®æ¦¡¤Æ (¤G®æ¬õ¦â ¤G®æªÅ) C2:I7=IF(ROW(A1)=1,C2<15,IF(ROW(A1)>4,C2>15,1))*(MOD(DATE($A$2,$A$5,C2),4)<2)

½Ð°Ý³o­n­þÃä¥Î?

TOP

­ø¡A¬°¤°»ò§Ú¬d¨ìªº½s¸¹¬O6436©O?
https://blog.xuite.net/hcm19522/twblog/588775126
¤£¹LÁÂÁÂH¤j¸Ñ¨M§Úªº°ÝÃD¡C

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD