Conditional formating problem

[excelent]

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

 

[Don Guillett]

Why no macro? Less overhead than CF

 

[roadkill]

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]

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: