1

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.

0

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.

enter image description here

  • Nope, I am using the "Color Scales" Conditional Formatting – taraesque May 19 '15 at 21:36
  • My thoughts would be going to individual cells and picking a font color that matches the fill color, or using one of the Conditional Formatting selections that allows for Custom Format such as I mentioned above. I don't know how you would do what you are asking using the "Color Scales" Conditional Formatting which is not to say that it can't be done. There are a lot of Excel experts on here, perhaps one of them will educate us both. – Clif May 19 '15 at 22:42
  • I think that I may have discovered a way to accomplish what you are trying to do. Select the cells that contain the text which you want to hide. Open the cell format dialog (Ctrl + 1). Select "Custom". In the "Type" box input ;;; (three semicolons). Select OK. This will hide the text in the selected cells. – Clif May 20 '15 at 13:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.