¥Î³]©w®æ¦¡¤Æ±ø¥óÀ˵ø¸ê®Æ°ÝÃD
- ©«¤l
- 101
- ¥DÃD
- 34
- ºëµØ
- 0
- ¿n¤À
- 139
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Macau
- µù¥U®É¶¡
- 2010-7-1
- ³Ì«áµn¿ý
- 2014-1-30
|
¥Î³]©w®æ¦¡¤Æ±ø¥óÀ˵ø¸ê®Æ°ÝÃD
§Ú·Q§Q¥Î³]©w®æ¦¡¤Æ±ø¥óÀ˵ø¤£¦s¦bªº¼ÆÈ¥X¤F°ÝÃD½Ð°ª¤âÌ«ü¾É.
¨C¤é¼Æ.rar (9.37 KB)
|
|
|
|
|
|
|
- ©«¤l
- 472
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 485
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows
- ³nÅ骩¥»
- MS Office
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »´ä
- µù¥U®É¶¡
- 2010-7-4
- ³Ì«áµn¿ý
- 2014-12-28
|
©ÎªÌ¥i¥H»¡»¡§A·Q¥Î®æ¦¡¤Æ±ø¥ó°µ¨Ç¤°»ò®ÄªG? |
|
|
|
|
|
|
- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 1# mmggmm
¦h½d³òªºÀx¦s®æ®æ¦¡¤Æ±ø¥ó ªº¤½¦¡ ¶·¥H§@¥Î¤¤ªºÀx¦s®æ¬°¥D
³o¬O§AÀÉ®×A5ªº¤½¦¡¥¿½T =COUNTIF($Q$6:$Q$65536,$A5)<1
F5ªº¤½¦¡¿ù»~ =COUNTIF(R$6:U$42,$E5)<1
- Sub EX()
- [A5:N65536].FormatConditions.Delete
- With [A5:A65536,C5:C65536,E5:E65536,G5:G65536,I5:I65536,K5:K65536,M5:M65536] '¦h½d³òªºÀx¦s®æ
- .Select '®æ¦¡¤Æ±ø¥ó¶·°é¿ï½d³ò
- .Cells(1).Activate '°é¿ï½d³ò¤¤¤§ A5¬°§@¥Î¤¤ªºÀx¦s®æ
- .FormatConditions.Delete '§R°£ì½d³ò¤¤®æ¦¡¤Æ±ø¥ó
- .FormatConditions.Add Type:=xlExpression, Formula1:= _
- "=COUNTIF($Q$6:$Q$77," & .Cells(1).Address(0, 0) & ")<1"
- '¥H¤Wªº¤½¦¡ =COUNTIF($Q$6:$Q$65536,A5)<1
- '¦p.Cells(2).Activate '°é¿ï½d³ò¤¤Åܦ¨ A6¬O§@¥Î¤¤ªºÀx¦s®æ
- '¥H¤Wªº¤½¦¡ =COUNTIF($Q$6:$Q$65536,A6)<1
- '§@¥Î¤¤ªºÀx¦s®æ¬°¥D §_«h¤½¦¡´N¿ù±¼
- .FormatConditions(1).Font.ColorIndex = 3
- .Cells(1).Select
- End With
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 101
- ¥DÃD
- 34
- ºëµØ
- 0
- ¿n¤À
- 139
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Macau
- µù¥U®É¶¡
- 2010-7-1
- ³Ì«áµn¿ý
- 2014-1-30
|
kimbal§A¦n,§Ú¥Dn·Q¥ÎQÄ檺¼ÆȨӧPÂ_A,C,E,G,I,K,M,7Ä椺©Ò¿é¤Jªº¼ÆȦ³ÉN¿ù»~¦p¦³´N¥ÎÃC¦â«ü¥X¿ù³B |
|
|
|
|
|
|
- ©«¤l
- 472
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 485
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows
- ³nÅ骩¥»
- MS Office
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »´ä
- µù¥U®É¶¡
- 2010-7-4
- ³Ì«áµn¿ý
- 2014-12-28
|
¦^´_ 4# mmggmm
um.... §A¦bexcel¤W°ÝÃD¬O¦b°ÝFÄæ, §Ú´Nª½±µ¬ÝFÄ檺:
F5ªº±ø¥ó:
=COUNTIF(R$6:U$42,$E5)<1
R6:U42 ¤W³£¨S¦³301, ©Ò¥H´N¥X¬õ¦â.
¯d·N¤@ÂI¬O¦pªG¼Æ¾Ú¥[´î¤F, ¬On¥Î´¡¤J/§R°£,¦Ó¤£¬O¶K¤WÈ
´¡¤J/§R°£ªº¸Ü,±ø¥óªº®æ¦¡·|¸ò·s¥[¦æ¼ÆÁY¤p¼W¤j, ¦ý¶K¤WȪº¸Ü´N¤£·|. |
|
|
|
|
|
|
- ©«¤l
- 1180
- ¥DÃD
- 204
- ºëµØ
- 0
- ¿n¤À
- 1051
- ÂI¦W
- 0
- §@·~¨t²Î
- Mac.OS10.6
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2012-9-19
|
¥»©«³Ì«á¥Ñ PD961A ©ó 2010-8-9 07:49 ½s¿è
½Ð°Ýª©¥D
¤U¸üHSª©¥Dªº¨C¤é¼ÆÀÉ®×..
·s¼W¤u§@ªí«á..
ì¤u§@ªí¦WºÙ·|Åܦâ
½Ð°Ý³]©w¨ìþ¸Ì?
n¦p¦ó§ï¦^¨Ó¥¿±`µLÃC¦â?
ÁÂÁ±z...
|
|
¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h
|
|
|
|
|
- ©«¤l
- 101
- ¥DÃD
- 34
- ºëµØ
- 0
- ¿n¤À
- 139
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Macau
- µù¥U®É¶¡
- 2010-7-1
- ³Ì«áµn¿ý
- 2014-1-30
|
Hsieh:
¥¼¯à¤U¸ü§Aªº¤å¥ó,²{¨Ì§Aªº¤èªk°µ,¦ýµ²ªG¤£¬O·Qnªº½Ð«ü¥X¿ù¦bþ¸Ì
¨C¤é¼Æ3.rar (12.23 KB)
|
|
|
|
|
|
|