Results 1 to 3 of 3

Thread: Excel -

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Mar:2008
    Location: BG
    Posts: 162

    Excel -

    Excel 2003. . .

    Code:
    Dim cell As Range
    For Each cell in Range("E8:AM175")
    If cell.Interior.ColorIndex < 0 Then
    '   (  )         < 0 
    cell.Interior.ColorIndex = 3 
    
    
    End If
    Next cell
    End Sub
    ? - Range("E8:AM175") < 0

  2. #2
    Registered User Zlatena's Avatar
    Join Date: Oct:2007
    Location: BG
    Posts: 285
    workbook E8:AM175 .
    - 1, .
    E8:AM175 , .
    , , workbook?
    , , .

  3. #3
    Registered User
    Join Date: Mar:2008
    Location: BG
    Posts: 162
    ' cell.Interior.ColorIndex = 3
    If cell.Interior.ColorIndex < 0 Then .

    workbook Book1 - E8:AM175 < 0 xlNone. workbook Book2 Book1.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |