Conditional formatting: hidden number data

[Catherine_George]

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 seems to be hidden 'behind' the colour, when I am used to it being in front/on top of the colour.  I am grateful for any advice / instructions on how to reverse this to the usual (number visible with coloured background). I don't want to lose the conditional formatting which is RAGging the data.  Thank you!

[#2 · Accepted solution]

@Catherine_George 

• 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?

[#3]

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?

[#4]

@Catherine_George 

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.