Hi!
I have a list of numbers, and I applied a conditionnal formatting, a colorscale.
But I want to use the color given by the conditionnal formatting to color forms. So first I want to have the color number, or another list of cells colored with "Interior.color" and not with the coniditionnal formatting.
I've seen some functions, made by byunt "get cell color" (I can't insert links, but it's somewhere in this website!)
But it's not working in excel 2007 with a colorscale.
Does anybody has an idea ?
Thanks in advance.
Thibaut