Excel Dynamic Color-Coding Project - 24/10/2024 13:01 EDT
Budget: $30 – $250 USD
I need an expert Excel professional to help me with a dynamic cell coloring project.
Key Tasks:
- Color all rows in the 'Km Project' sheet based on certain criteria.
- Use the 'GRAPHIC' sheet to determine the color based on matching cell value ranges.
- Implement the same cell colors as shown on the 'GRAPHIC' sheet for specific numerical ranges.
The 'Summary' sheet doesn't require any modifications.
Ideal Skills and Experience:
- Proven experience with advanced Excel functionalities.
- Strong understanding of Excel's conditional formatting and dynamic data updating.
- Ability to replicate pre-existing color coding schemes accurately.
Please note, the project requires the 'GRAPHIC' sheet to automatically update whenever data is changed.
Key Tasks:
- Color all rows in the 'Km Project' sheet based on certain criteria.
- Use the 'GRAPHIC' sheet to determine the color based on matching cell value ranges.
- Implement the same cell colors as shown on the 'GRAPHIC' sheet for specific numerical ranges.
The 'Summary' sheet doesn't require any modifications.
Ideal Skills and Experience:
- Proven experience with advanced Excel functionalities.
- Strong understanding of Excel's conditional formatting and dynamic data updating.
- Ability to replicate pre-existing color coding schemes accurately.
Please note, the project requires the 'GRAPHIC' sheet to automatically update whenever data is changed.