Forum Discussion
Solved
Conditional formatting: hidden number data
Hello, Probably a basic question, but I can't match anything I search to the help resource. I have a conditionally formatted table but can only see the number data for a cell when clicked on. It see...
- Check the number format of the cells. The number format ;;; (three semicolons in a row) will hide all values.
- Check the conditional formatting rules - has the font color been set to the same as the fill color?
- Check the number format of the cells. The number format ;;; (three semicolons in a row) will hide all values.
- Check the conditional formatting rules - has the font color been set to the same as the fill color?
Hi, Thank you so much! Yes it was the font colour being set to the same as the fill. I really appreciate your help. Learning a lot this morning! Shall I delete the post - or can it be closed?
You should not delete it - others might learn from it.
If you wish, you can mark my previous reply as the best response. That will show that the problem has been solved.