Good evening everyone,
Here is the scenario I face while utilizing the conditional formatting tool:
In sheet 1 I have a column of values whose font color is adjusted based on 4 conditions. In sheet 2 I have rearranged this column of values into a chart to present my data. I assumed the font color of the values in Sheet 1 would carry over, but I soon discovered this is not the case. I could apply the conditional format tool to my cells in Sheet 2 to tie back to the original condition I created in Sheet 1. However, the table in Sheet 2 needed to be arranged in a way that this will take forever to accomplish and leave much room for mistakes when creating the countless formulas.
Would anyone have any advice on how I could format my results in Sheet 2 to keep the colored font created for the values in Sheet 1?
Bookmarks