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

[µo°Ý] ¦Û°Ê§P©w¦¨ÁZ¦X®æ¤Î¤£¦X®æ¡A¦ý¤£¬O¨Ì¤À¼Æ§P©w

[µo°Ý] ¦Û°Ê§P©w¦¨ÁZ¦X®æ¤Î¤£¦X®æ¡A¦ý¤£¬O¨Ì¤À¼Æ§P©w

¦U¦ì°ª¤â¤j¤j

¦bEXCEL­n¦p¦ó§P©w¦¨ÁZ¦Û¤v¨q¥X¦X®æ¤Î¤£¦X®æ¡A¦ý¨Ã¤£¬O¨Ì·Ó¤À¼Æ¡A¦Ó¬O¨Ì·Ó¦pªG¤@­Ó¬ì¥Ø¤¤¦³¤@­Ó¦¨ÁZ¬O¬õ¦âªº´N¦Û¤v¨q¥X¤£¦X®æ
ªþ¤W¹ÏÀɤÎexcel¾×
·PÁÂ
¦p¦ó§P©w.zip (9.86 KB)

¦p¤U

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
For M = 4 To 9
If Sheet1.Cells(M, 6).Font.ColorIndex = 3 Or Sheet1.Cells(M, 8).Font.ColorIndex = 3 Or Sheet1.Cells(M, 10).Font.ColorIndex = 3 Or Sheet1.Cells(M, 12).Font.ColorIndex = 3 Then
  Sheet1.Cells(M, 14) = "¤£¦X®æ"
  Else
  Sheet1.Cells(M, 14) = "¦X®æ"
End If
Next
End Sub
ù

TOP

+¤£¦X®æ¦Û°Ê¨q¬õ¦â

Sub AA()
For M = 4 To 9
If Sheet1.Cells(M, 6).Font.ColorIndex = 3 Or Sheet1.Cells(M, 8).Font.ColorIndex = 3 Or Sheet1.Cells(M, 10).Font.ColorIndex = 3 Or Sheet1.Cells(M, 12).Font.ColorIndex = 3 Then
  Sheet1.Cells(M, 14) = "¤£¦X®æ"
  Sheet1.Cells(M, 14).Font.ColorIndex = 3
  Else
  Sheet1.Cells(M, 14) = "¦X®æ"
End If
Next

End Sub
ù

TOP

¦^´_ 1# qq78787


¦p¦ó§P©w.rar (11.44 KB)
  °ò¥»¤è¦¡
N4¿é¤J
=IF(OR(F4="",H4="",J4="",L4=""),"",IF(OR(F4<60,H4<60,J4<60,L4<60),"¤£¦X®æ","¦X®æ"))
©Î
N4¿é¤J
=IF(OR(F4="",H4="",J4="",L4=""),"",IF(SUMPRODUCT(N(F4:M4<60))>4,"¤£¦X®æ","¦X®æ"))
N4¿é¤J
=IF(OR(F4="",H4="",J4="",L4=""),"",IF(COUNTIF(F4:M4,">=60")=4,"¦X®æ","¤£¦X®æ"))
ÃC¦â³¡¥÷¨Ï¥Î
³]©w®æ¦¡¤Æªº±ø¥ó¥h³]©w
¤£¦X®æ ¬õ¦â
§C©ó60¤À¬õ¦â

TOP

¦^´_ 3# rouber590324

rouber590324  ¤j¤j§A¦n

½Ð°Ý§Ú½Æ»s³o¬q¤W¥h ¥L¬°¦ó·|¿ù?

¦A½Ð§A«ü±Ð¤F ·PÁÂ~

TOP

DEAR SIR
1±N¦p¤UÂлs¨ì§A¦³¸ê®Æ¤§SHEET1 "¤u§@ªí¤¤"´NOK°Õ
  ¤£­n¸m©óMODULE


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
For M = 4 To 9
If Sheet1.Cells(M, 6).Font.ColorIndex = 3 Or Sheet1.Cells(M, 8).Font.ColorIndex = 3 Or Sheet1.Cells(M, 10).Font.ColorIndex = 3 Or Sheet1.Cells(M, 12).Font.ColorIndex = 3 Then
  Sheet1.Cells(M, 14) = "¤£¦X®æ"
  Sheet1.Cells(M, 14).Font.ColorIndex = 3
  Else
  Sheet1.Cells(M, 14) = "¦X®æ"
  Sheet1.Cells(M, 14).Font.ColorIndex = 1
End If
Next
End Sub
ù

TOP

¦^´_ 6# rouber590324

rouber590324  ¤j¤j§A¦n
¹ï¤£°_ ÁÙ¬O¦³¿ù??¬O¤£¬O§Ú¤S½Æ»s¿ù¦a¤è¤F?
¦pªG¤è«K¥i¥H¶K­Ó¹ÏÅý§Ú¾Ç²ß~~ÁÂÁÂ

TOP

§Ú¤½¥qÀɶÇÀÉ®×»P¹Ï¤ù¥\¯à-¤£µM¦­¤W¶ÇZIPÀɵ¹§A©Ô
§Ú¬Ý¬OªO¥»°ÝÃD
§Ú±N SHEET1 §ï ¤u§@ªí1 ¦A¸Õ¸Õ
¦]¥¦§ä¤£¨ì SHEET1 ¬G¨q¥X BUG

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
For M = 4 To 9
If ¤u§@ªí1.Cells(M, 6).Font.ColorIndex = 3 Or ¤u§@ªí1.Cells(M, 8).Font.ColorIndex = 3 Or ¤u§@ªí1.Cells(M, 10).Font.ColorIndex = 3 Or ¤u§@ªí1.Cells(M, 12).Font.ColorIndex = 3 Then
  ¤u§@ªí1.Cells(M, 14) = "¤£¦X®æ"
  ¤u§@ªí1.Cells(M, 14).Font.ColorIndex = 3
  Else
  ¤u§@ªí1.Cells(M, 14) = "¦X®æ"
  ¤u§@ªí1.Cells(M, 14).Font.ColorIndex = 1
End If
Next
End Sub
ù

TOP

¦^´_ 8# rouber590324

¦³¤F¦³¤F
ÁÂÁ§A~~ :)

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD