PDA

View Full Version : excel2k FormatConditions question



L@ja
01-29-2008, 05:40 AM
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...:help ?dv:/regardsL@ja

Norie
01-29-2008, 05:46 AM
If the cells are coloured using conditional formatting then you are going to have a difficult time selecting them.

You might find something here (http://www.cpearson.com/Excel/CFColors.htm).

But I have to ask what you are actually trying to do.

Bob Phillips
01-29-2008, 05:55 AM
You have an answer in the public newsgroups where you have cross-posted this.

L@ja
01-29-2008, 05:56 AM
many 10x
your link are really helpfull

:bow: