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

[µo°Ý] ½Ð°Ý¦³¨ç¼Æ¥i¥H§ä¥XÀx¦s®æ¨s«Y¼Æ¦r©Î¦³¤U¤½¦¡

[µo°Ý] ½Ð°Ý¦³¨ç¼Æ¥i¥H§ä¥XÀx¦s®æ¨s«Y¼Æ¦r©Î¦³¤U¤½¦¡

AÄ榳´X¤dµ§¸ê®Æ¡A¨Ò¦p¨ä¤¤¦³¥i¯àA3=A1(¼Æ¦r)+A2(¼Æ¦r)¡BA5=A4(¼Æ¦r)¡BA9=SUM(A6:A8)¡AAÄ榳¤@¨ÇÀx¦s®æ¦s¦³±_ª¬¤p­p¡A½Ð°Ý§Ú­n¤À¿ë¥XAÄ樺¨ÇÀx¦s®æ¬O¯Â¼Æ¦r¡B­þ¨ÇÀx¦s®æ¬O±a¦³¤½¦¡©Î¨ç¼Æ
julie

¦^´_ 1# julieh96590


   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

选Àx¦s®æA1:A9 >> «ö Ctrl+G >> 选"¯S别" >> 选择"¤½¦¡" >> OK >> 选Àx¦s®æ®æ¦¡"红¦â"为©³¦â

TOP

­Y¬O¼Æ¦r+¼Æ¦r(¦p: "=2+3")­nµø¬°¼Æ¦r©Î¤½¦¡©O?

TOP

­Y¬O¼Æ¦r+¼Æ¦r(¦p: "=2+3")­nµø¬°¼Æ¦r©Î¤½¦¡©O?
Jevon µoªí©ó 2013-1-25 14:40


Àx¦s®æ "=2+3"

¦³ "="

µø¬°¤½¦¡

TOP

ÁÂÁ¤G¦ì«e½ú¸Ñµª¡A¨ü¥ÎµL½a¡A¤w¸Ñ¨M°ÝÃD¡A¦ý¤S­l¥Í¥X¤@­Ó¤£À´ªº¨ç¼ÆGET.CELL(6,¡K)¡A¦Ó¥B¦b2007§ä¤£¨ì¡A¥i§_¸Ô­z¦¹ºØ¨ç¼Æ¥Îªk
julie

TOP

¦^´_ 6# julieh96590
¦b¤u§@ªí¤ºªºÀx¦s®æ¤º­n¤Þ¥Îªº¸Ü,
¥i¥H±q©w¸q¦WºÙ¸Ì³]©w¦p¹Ï

TOP

¦^´_ 6# julieh96590
GET.CELL¬O§»ªí¨ç数
¦V°ª¤â学习

TOP

¥H¤U§»¡A给©Ò¦³§t¤½¦¡ªº单¤¸®æ标记颜¦â¡A¥uÓì¦XExcel 2010
»ª¦üª½±µ¥ÎCtrl+G©w¦ì条¥ó§óª½观¡A¨þ¨þ
  1. Sub MarkFunc()
  2. Dim rng As Range
  3. Dim 红 As Integer, 绿 As Integer, 蓝 As Integer
  4.     红 = 255
  5.     绿 = 123
  6.     蓝 = 100
  7. For Each rng In Worksheet
  8. If rng.HasFormula Then
  9. rng.Interior.Color = RGB(红, 绿, 蓝)
  10. End If
  11. Next rng
  12. End Sub
½Æ»s¥N½X
¦V°ª¤â学习

TOP

·PÁÂJBY¤j¤j.±zªº¤èªk¯u¬O¦n¥Î·¥¤F
¦~ÄÖ¤£¤p,¦ý§Ú«Ü·Q¾Ç

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD