E
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
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