Spreadsheet macros for coloring sequence alignments

Area of Science:

• Bioinformatics
• Computational Biology
• Molecular Biology

Context:

• Sequence alignment is crucial for understanding biological relationships.
• Visualizing sequence data aids in identifying patterns and features.
• Existing tools may lack user-friendly interfaces for specific visualization tasks.

Purpose:

• To describe a set of Microsoft Excel macros for coloring amino acid and nucleotide sequence alignments.
• To facilitate the preparation of visual aids for biological sequence analysis.
• To simplify the process of importing and coloring sequences for researchers.

Summary:

• The article details Microsoft Excel macros that automatically color amino acid and nucleotide sequence alignments.
• These macros enhance sequence review and the creation of visual aids by allowing feature emphasis.
• A custom menu simplifies macro usage for users unfamiliar with Excel, supporting both Macintosh and DOS versions.

Impact:

• Provides a user-friendly, accessible tool for visualizing biological sequence data.
• Improves the efficiency of sequence analysis and interpretation.
• Enables researchers to create customized, informative visual representations of sequence alignments.