Is there a way to make the tab color change with the color of a cell on that worksheet?
Example: Workbook “CUSTOMER CONTACT” has several worksheets. One worksheet is titled “Cold Calls”, another is titled “Mailings”. In cell C1 on the “Cold Calls” worksheet, the cell changes color based on a percentile set from conditional formatting. In cell D5 on the “Mailings” worksheet, the cell changes color based on a specific text set from conditional formatting.
I want the “Cold Calls” tab in my workbook to change colors along with the color on that same worksheet (“Cold Calls”) of cell C1.
I want the “Mailings” tab in my workbook to change colors along with the color on that same worksheet (“Mailings”) of cell D5
If it can be done, do the colors have to be ‘prime’ colors (in other words, no variations of colors, just the set colors allowed)?
etc., etc. etc.
TIA
Example: Workbook “CUSTOMER CONTACT” has several worksheets. One worksheet is titled “Cold Calls”, another is titled “Mailings”. In cell C1 on the “Cold Calls” worksheet, the cell changes color based on a percentile set from conditional formatting. In cell D5 on the “Mailings” worksheet, the cell changes color based on a specific text set from conditional formatting.
I want the “Cold Calls” tab in my workbook to change colors along with the color on that same worksheet (“Cold Calls”) of cell C1.
I want the “Mailings” tab in my workbook to change colors along with the color on that same worksheet (“Mailings”) of cell D5
If it can be done, do the colors have to be ‘prime’ colors (in other words, no variations of colors, just the set colors allowed)?
etc., etc. etc.
TIA