Conditional formating problem
 

Hi all

got a non static list like this 1

List wanted color
xxxBxxx1 light grey
xxxBxxx2 light grey
xxxBxxx3 light grey
xxxDxxx5 dark grey
xxxFxxx9 light grey
xxxFxxx1 light grey
xxxFxxx3 light grey
xxxFxxx7 light grey
xxxJxxx3 dark grey
xxxJxxx1 dark grey
xxxPxxx2 light grey

now i wana use conditional format (not vba) to
color betwin 2 difrent background-colors every time list change
letter in 4 position
The list can be longer and/or shorter and change too
Is that possible ?

Xecel 2003 - Vista

Conditional formating problem
 

Why no macro? Less overhead than CF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"excelent" wrote in message
...
Hi all

got a non static list like this 1

List wanted color
xxxBxxx1 light grey
xxxBxxx2 light grey
xxxBxxx3 light grey
xxxDxxx5 dark grey
xxxFxxx9 light grey
xxxFxxx1 light grey
xxxFxxx3 light grey
xxxFxxx7 light grey
xxxJxxx3 dark grey
xxxJxxx1 dark grey
xxxPxxx2 light grey

now i wana use conditional format (not vba) to
color betwin 2 difrent background-colors every time list change
letter in 4 position
The list can be longer and/or shorter and change too
Is that possible ?

Xecel 2003 - Vista

Conditional formating problem
 

If I understand your question correctly I see a way to do it if you don't
mind adding a column (which you could hide). Assuming your data below starts
in row 2 (with the list being in column A and the added column being column
B), put a 1 in B2 and then in B3 put the formula
"=if(mid(A3,4,1)=mid(A2,4,1),b2,-b2)". Copy this formula down as far as your
data goes. You can then use the data in column B to set your background
colors (using the "Formula is" option in conditional formatting).
Will

"excelent" wrote:

Hi all

got a non static list like this 1

List wanted color
xxxBxxx1 light grey
xxxBxxx2 light grey
xxxBxxx3 light grey
xxxDxxx5 dark grey
xxxFxxx9 light grey
xxxFxxx1 light grey
xxxFxxx3 light grey
xxxFxxx7 light grey
xxxJxxx3 dark grey
xxxJxxx1 dark grey
xxxPxxx2 light grey

now i wana use conditional format (not vba) to
color betwin 2 difrent background-colors every time list change
letter in 4 position
The list can be longer and/or shorter and change too
Is that possible ?

Xecel 2003 - Vista

Conditional formating problem
 

roadkill:
Y i ges thats the only way vithout VBA, not what i hoped for,
but then again u cant get it all right :-)

Don : ur right vba would be the easy way, but i cant use it this time

thanks both for ur help

"roadkill" skrev:

If I understand your question correctly I see a way to do it if you don't
mind adding a column (which you could hide). Assuming your data below starts
in row 2 (with the list being in column A and the added column being column
B), put a 1 in B2 and then in B3 put the formula
"=if(mid(A3,4,1)=mid(A2,4,1),b2,-b2)". Copy this formula down as far as your
data goes. You can then use the data in column B to set your background
colors (using the "Formula is" option in conditional formatting).
Will

"excelent" wrote:

Hi all

got a non static list like this 1

List wanted color
xxxBxxx1 light grey
xxxBxxx2 light grey
xxxBxxx3 light grey
xxxDxxx5 dark grey
xxxFxxx9 light grey
xxxFxxx1 light grey
xxxFxxx3 light grey
xxxFxxx7 light grey
xxxJxxx3 dark grey
xxxJxxx1 dark grey
xxxPxxx2 light grey

now i wana use conditional format (not vba) to
color betwin 2 difrent background-colors every time list change
letter in 4 position
The list can be longer and/or shorter and change too
Is that possible ?

Xecel 2003 - Vista