ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excel2k FormatConditions question (https://www.excelbanter.com/excel-programming/405212-excel2k-formatconditions-question.html)

L@ja

excel2k FormatConditions question
 
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.colorindex

little snippets higly appreciated
many thanx before...
--
üdv:/regards
L@ja

Bob Phillips

excel2k FormatConditions question
 
See http://www.xldynamic.com/source/xld.CFConditions.html

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"L@ja" wrote in message
...
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.colorindex

little snippets higly appreciated
many thanx before...
--
dv:/regards
L@ja




L@ja

excel2k FormatConditions question
 
10x
I get it he
http://www.cpearson.com/Excel/CFColors.htm

--
üdv:regards
L@ja


Bob Phillips ezt *rta:

See http://www.xldynamic.com/source/xld.CFConditions.html

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"L@ja" wrote in message
...
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.colorindex

little snippets higly appreciated
many thanx before...
--
üdv:/regards
L@ja





Bob Phillips

excel2k FormatConditions question
 
But the page I gave isn't subjected to the limitations that Chip has on his
page.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"L@ja" wrote in message
...
10x
I get it he
http://www.cpearson.com/Excel/CFColors.htm

--
dv:regards
L@ja


"Bob Phillips" ezt rta:

See http://www.xldynamic.com/source/xld.CFConditions.html

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"L@ja" wrote in message
...
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.colorindex

little snippets higly appreciated
many thanx before...
--
dv:/regards
L@ja







L@ja

excel2k FormatConditions question
 
I get this errmsg if i try to use your link
This account has exceeded it's bandwidth quota and has been temporarily
disabled.

:-)

--
üdv:regards
L@ja


Bob Phillips ezt *rta:

But the page I gave isn't subjected to the limitations that Chip has on his
page.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"L@ja" wrote in message
...
10x
I get it he
http://www.cpearson.com/Excel/CFColors.htm

--
üdv:regards
L@ja


"Bob Phillips" ezt *rta:

See http://www.xldynamic.com/source/xld.CFConditions.html

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"L@ja" wrote in message
...
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.colorindex

little snippets higly appreciated
many thanx before...
--
üdv:/regards
L@ja







Bob Phillips

excel2k FormatConditions question
 
Do you want me to send you the page offline? If so, give me an addy.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"L@ja" wrote in message
...
I get this errmsg if i try to use your link
This account has exceeded it's bandwidth quota and has been temporarily
disabled.

:-)

--
dv:regards
L@ja


"Bob Phillips" ezt rta:

But the page I gave isn't subjected to the limitations that Chip has on
his
page.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"L@ja" wrote in message
...
10x
I get it he
http://www.cpearson.com/Excel/CFColors.htm

--
dv:regards
L@ja


"Bob Phillips" ezt rta:

See http://www.xldynamic.com/source/xld.CFConditions.html

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"L@ja" wrote in message
...
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.colorindex

little snippets higly appreciated
many thanx before...
--
dv:/regards
L@ja










All times are GMT +1. The time now is 12:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com