Quote Originally Posted by arlu1201 View Post
This can be done through VBA. Please provide the conditions in detail.
The spreadsheet that was attached to the original post essentially has the detail of how the color coding should work.

Assume my data has 5 columns.
Column A - Rev Type
Columb B - Stage
Column C - Duration (which is the column we want to color code)
Columd D - Vertical

Based on the spreadsheet in the original, I need to color code the Duration field based on the color matrix in the spreadsheet. The spreadsheet in the original only has the color code table and not actual data. I didn't think that was necessary. Let me know if you still need more.