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

®æ¦¡¤Æ±ø¥ó³]©w

®æ¦¡¤Æ±ø¥ó³]©w

·Q½Ð°Ý¦pªGEXCEL ·Q³]©w¦pªG¬Y¤@Äæµ¥©ó¬Y­È
«h¾ã¦C¤Ï¥Õ(©Î³]©w¶ñº¡¬YÃC¦â),¸Ó¦p¦ó³]©w©O?
EXCEL.JPG

DEAR  SIR
1.¦p¹Ï¤@ °²³] BÄæ=10  ¸Ó¦C¨q¥X©³¦âÂÅ.

¹Ï¤@
Private Sub Worksheet_Change(ByVal Target As Range)
   X = Sheet1.[B65536].End(xlUp).Row
For M = 2 To X
If Sheet1.Cells(M, 2) = "10" Then
    Rows("" & M & ":" & M & "").Select
    With Selection.Interior
        .ColorIndex = 34
        .Pattern = xlSolid
    End With
     Y = Y + 1
   End If
   Next
End Sub
ù

TOP

®æ¦¡¤Æ (¤@) Àx¦s«á ¤U¸ü ¶·­«³] =OR($C2:$E2=0)
®æ¦¡¤Æ (¤G) =($C2<>0)*($D2<>0)*($E2<>0)=0
®æ¦¡¤Æ (¤T) =($C2=0)+($D2=0)+($E2=0)>0
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD