Results 1 to 6 of 6

Thread: Excel, get conditinal formatting font color in VBA

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2001
    Location
    N42 29.340 W71 53.215
    Posts
    422

    Resolved Excel, get conditinal formatting font color in VBA

    I have a spreadsheet in Excel that uses the conditional formatting formulas to set cell font colors when they exceed certain limits.
    e.g. cells > x have their font color set to Blue.

    I've been trying to read the individual cell font colors from within a VBA function, e.g.
    Code:
        Debug.Print rng.Font.Color
        Debug.Print rng.Font.FontStyle
        Debug.Print rng.Font.ColorIndex
        Debug.Print rng.Interior.Color
    But this doesn't seem to know about the conditional formatting changes,
    i.e. it returns the basic, default color info for the cell.

    Is the actual, current font color info, as seen by the user, discernable via code somewhere?

    Thanks, DaveBo
    Last edited by DaveBo; May 5th, 2005 at 03:53 PM.
    "The wise man doesn't know all the answers, but he knows where to find them."
    VBForums is one place, but for the really important stuff ... here's a clue 1Tim3:15

Posting Permissions

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



Click Here to Expand Forum to Full Width