I have used the Conditional Formatting to change the Cell fill color based on the percentage number. However, I would like to hide the text so I just have a bunch of colored squares with no value showing. Is there Conditional Formatting that will change the text color to match the background cell fill color or something else I could do? I am in Excel 2010.
I am making an assumption that you used the "greater than" and/or "less than" rules to apply conditional formatting to the cells based on the percentage number. If you use the "custom format" option you can select that the "fill" and "font" be the same color. BTW this would also work for some of the other conditional formatting rules.