- ©«¤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# RJR
³]©w®æ¦¡¤Æªº±ø¥ó1 ¤½¦¡ =AND(TEXT($B1,"hh:mm")="15:00",TEXT($B65536,"hh:mm")<>"15:00")
³]©w®æ¦¡¤Æªº±ø¥ó2 ¤½¦¡ =$A1<>$A2
¿ï©w½d³ò«á§@¥Î¤¤Àx¦s®æ ¦p¹Ï
2003ª©¥» ³]©w®æ¦¡¤Æªº±ø¥ó, ¥~®Øªº®æ¦¡¨S¦³ Âù¾î½u¥i³] .¸Õ¸Õvba
- Sub Ex()
- Dim Rng As Range, E As Range, T As Boolean
- Set Rng = ActiveSheet.Range("A1:D" & ActiveSheet.[A1].End(xlDown).Row)
- T = False
- Rng.Borders.LineStyle = xlNone
- For Each E In Rng.Rows
- If E.Cells(1, 1) = E.Cells(2, 1) And E.Cells(1, 2) = TimeValue("15:00") And T = False Then
- T = True
- E.Borders(xlTop).LineStyle = xlDouble
- ElseIf E.Cells(1, 1) <> E.Cells(2, 1) And E.Row <> Rng.Cells(Rng.Count).Row Then
- E.Borders(xlEdgeBottom).LineStyle = xlContinuous
- T = False
- End If
- Next
- End Sub
½Æ»s¥N½X |
|