Digita
04-14-2008, 09:56 PM
Hi guys,
I have a long list of names with many duplicate entries. I would like to apply alternate color coding via conditional format to separate different group names, something similar to the alternate row coloring in conditional format (with the use of function MOD(ROW(),2)=0) but rather on group name similarities. For example, in a column, I have:
AA
AA
AAA
AAA
AAB
Using conditional format, I?d like to mark the 3 rows containing AA & AAB with green background and leave the 2 rows in between containing AAA in white.
As usual, thank you in advance for any suggestions.
Regards
kp
I have a long list of names with many duplicate entries. I would like to apply alternate color coding via conditional format to separate different group names, something similar to the alternate row coloring in conditional format (with the use of function MOD(ROW(),2)=0) but rather on group name similarities. For example, in a column, I have:
AA
AA
AAA
AAA
AAB
Using conditional format, I?d like to mark the 3 rows containing AA & AAB with green background and leave the 2 rows in between containing AAA in white.
As usual, thank you in advance for any suggestions.
Regards
kp