mark15jill

¦^´_  GBKEE


With Sheet1                        (³o¥y¬O§_§ïWith State sheet?)
With Sheet2      ...
198188 µoªí©ó 2013-3-9 23:00

    With Sheet1                        (³o¥y¬O§_§ïWith State sheet?)  ³oºØ¼gªkÀ³¸Ó·|¥X²{¿ù»~
°£«D¦³¥t¥~«Å§i

198188

¦^´_ 28# GBKEE

If Worksheets("OHC").Range("G" & i) - Date <= 2 Then
    Worksheets("OHC").Range("G" & i).Interior.Color = RGB(255, 251, 45)
    Worksheets("OHC").Range("G" & i).Font.ColorIndex = RGB(217, 24, 9)
    End If

½Ð°Ý¤j¤j¡AIf Worksheets("OHC").Range("G" & i) - Date <= 2 Then ³o¥y­þ¸Ì¥X²{°ÝÃD¤F¡H

mark15jill

¦^´_  GBKEE

If Worksheets("OHC").Range("G" & i) - Date
198188 µoªí©ó 2013-3-13 11:31

    If Worksheets("OHC").Range("G" & i) - Date   
  §â¨â¬q¤À¶}
If Worksheets("OHC").Range("G" & i)
-
Date

GBKEE

¦^´_ 32# 198188
If Worksheets("OHC").Range("G" & i) - Date <= 2 Then ³o¥y­þ¸Ì¥X²{°ÝÃD¤F¡H
±ø¥ó¦¡:  Range("G?")(<- ¥²»Ý¬O¤é´Á) - Date(·í¤Ñ¤é´Á)<=2(¤Ñ)
§A»¡¥X²{°ÝÃD¤F ,½Ð»¡©ú¥Õ!!

198188

¦^´_ 34# GBKEE


    ¨â­Ó³£¬O¤é´Á¡A¦ý¬O¹q¸£»¡typing mistake, ©Ò¥H§Ú·Q°Ý¬O¤£¬O§Úªº»yªk¦³¿ù¡H

GBKEE

¦^´_ 35# 198188
typing mistake ªºÂ½Ä¶¬O¿é¤J¿ù»~
½ÐÀˬd Range("g?")¬O§_¬O¼Æ¦r,©Î¶Ç¤WÀɮ׬ݬÝ

Hsieh

¦^´_ 32# 198188


    À³¸Ó³o¥y¿ù»~
Worksheets("OHC").Range("G" & i).Font.ColorIndex = RGB(217, 24, 9)
ColorIndex À³¸Ó¬O¼Æ­È¤£¥i¨Ï¥ÎRGB
¥i§ï¦¨
Worksheets("OHC").Range("G" & i).Font.Color = RGB(217, 24, 9)

apolloooo

like ·|¤ñ¸û¦n¥Î¡C