I have a spread sheet with a list of projects in one column and amounts in other columns for each project. The project cell background is manually set to a color and another cell in that row uses the ColorIndex() Function to provide the color index of that cell. The amounts have different text colors representing different items for each project and have conditional formatting to provide cell color but is irrelevant to the summing.
I want to be able to sum based upon the project cell color and the amount text color. All are manually set. Can someone help with a VBA function for this. I have not been able to figure this out. I have found similar threads but they use the cell fill and text color and I cannot use that.
Thank you.
I want to be able to sum based upon the project cell color and the amount text color. All are manually set. Can someone help with a VBA function for this. I have not been able to figure this out. I have found similar threads but they use the cell fill and text color and I cannot use that.
Thank you.