- ©«¤l
- 678
- ¥DÃD
- 147
- ºëµØ
- 0
- ¿n¤À
- 799
- ÂI¦W
- 0
- §@·~¨t²Î
- win 8
- ³nÅ骩¥»
- MS 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-2-9
- ³Ì«áµn¿ý
- 2022-1-20
|
¥»©«³Ì«á¥Ñ ziv976688 ©ó 2020-12-4 00:52 ½s¿è
¦^´_ 2# luhpro
ÁÂÁ±zªº¤£§[½ç¥¿¡C
¤w¸g¥i¥H¶¶§Q°õ¦æ¤F~·P®¦::lol
¤£¦n·N«ä¡A¬O§_¥i¥H½Ð±z±N¤u§@ªíªº¦WºÙ "Data"¡A§ï¦^¦pì½d¨Òªº¤u§@ªí¦WºÙ¡A
¦]¬°¹ê»ÚªºÀɮ׫ܦhÓ¡A¤u§@ªí¦WºÙ³£¬O "Data"¡A¦³¨Ç¤£¤è«K^^"
ÁÂÁ±z!
ÁÙ¦³¦C43~¦C56°õ¦æµL®Ä¡A½Ð¸Ô¨£49_´Á¶Z§RµP_¦X¼Æ±Æ§Ç-ªÅ¼ÆÁ`Äý(0´Á)-(2020-11-27)(¤u§@ªí¦WºÙ½d¨Ò)&49_´Á¶Z§RµP_¦X¼Æ±Æ§Ç-ªÅ¼ÆÁ`Äý(0´Á)-(2020-12-01)(¤u§@ªí¦WºÙ½d¨Ò)¤º¤§»¡©ú~
¬O§_¯à³Ò¾r±z¦bÀ°¦£¬Ý¬Ý¡C¦A¦¸ÁÂÁ±z !
´ú¸ÕÀÉ :
2020-1204.rar (89.46 KB)
'-§ìData¤é´Á=Àɮפé´Á,±N¤u§@ªíªº²Ä1¦C¸¹½X«ü©wªº¦rÃC©M©³¦â------¦C42
Set BK = ThisWorkbook
Set xF = Nothing
T = Format(Left(Right(A, 15), 10), "yyyy/m/d") & ChrW(160) '·j´MÀɮפé´Á
Set xF = BK.Sheets("DATA").Range("A:A").Find(T, Lookat:=xlPart) '·j´M=AÄæ¤é´Á
If Not xF Is Nothing Then
For V = 4 To 10
If xF(1, V) <> "" Then
[B1:AX1].Find(xF(1, V), Lookat:=xlWhole).Font.ColorIndex = IIf(V = 10, 3, 7) '±N=AÄæ¤é´Á¦Cªº²Ä1¦Cªº¸¹½X¼Ð¥Ü¦rÃC
End If
If xF(2, V) <> "" Then
[B1:AX1].Find(xF(2, V), Lookat:=xlWhole).Interior.ColorIndex = IIf(V = 10, 8, 6) '±N=(AÄæ¤é´Á¦C+1¦C)ªº²Ä1¦Cªº¸¹½X¼Ð¥Ü©³¦â
End If
Next V
End If '¦C56 |
|