excel 2010
this is odd.
i create some formatting rules to color fill cells in 1st sheet column A
example: create a formatting rule based on formula =MATCH(A1,Sheet1!$A:$A,0) then select a fill color
when i pull .Interior.ColorIndex from the cells i get 0
but if i then use the std fill from Font palette it works fine.
why is this?
CF is not "real" formatting, unlike regular formatting, it kinda "floats above" the cell, and formulas etc do not "see" it
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
try this
Please Login or Register to view this content.
hmmm, does this use a different set of color numbers? i ask because after recording macro for conditional formatting with fill, it uses FormatConditions(1).Interior.ColorOriginally Posted by Patronus
try thisPlease Login or Register to view this content.
but red is .Color=255
but using real fill, red is Interior.ColorIndex=3
why multiple properties for the same thing?
EDIT:
ok, even though the CF adds color using integers, the .DisplayFormat.Interior.ColorIndex does grab index #, so i am good.
Last edited by VB_kid; 06-08-2016 at 03:29 PM. Reason: more info
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks