Hello Dear All,I have to create a macro wich select some datas from a big table.the selection depend on the colorindex of font, but colored by formatconditions.not all formatconditions some, but coloring is same in each relevant cells.what is the preferred(or existing) way to asked the specified cell showed font.colorindexlittle snippets higly appreciatedmany thanx before...?dv:/regardsL@ja
L@ja
If the cells are coloured using conditional formatting then you are going to have a difficult time selecting them.
You might find something here.
But I have to ask what you are actually trying to do.
You have an answer in the public newsgroups where you have cross-posted this.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
many 10x
your link are really helpfull
L@ja
Posting Permissions
Reply With Quote
