|
-
May 5th, 2005, 10:59 AM
#1
Thread Starter
Hyperactive Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|