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?
Bookmarks