Are there any function that can return information on the color format of a cell?
N nc Apr 3, 2007 #1 Are there any function that can return information on the color format of a cell?
A Amit GK Apr 3, 2007 #3 CELL("color",reference) returns 1 if the cell is formatted in color for negative values; otherwise returns 0 (zero).
CELL("color",reference) returns 1 if the cell is formatted in color for negative values; otherwise returns 0 (zero).
B Bob Phillips Apr 3, 2007 #4 Function GetColorindex(rng as Range) GetColorindex = rng.Interior.Colorindex End Function but as a colour change triggers no events, it will not update if you change the colour. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
Function GetColorindex(rng as Range) GetColorindex = rng.Interior.Colorindex End Function but as a colour change triggers no events, it will not update if you change the colour. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
