Using MS Excel 2007 / 2007
I have cells which contain formula to copy data from equivalent cell on previous sheet, ie in February C26 sheet, it will show the data in January C26 sheet.
Consequently, I had a column of ‘0’ which I didn’t want showing, so used Conditional Formatting to set ‘If C26 = 0, then font colour same as background’ for the whole column
This works very well in that it hides the ‘0’s.
However, when data is entered into the ‘empty’ cells, ie those with the ‘0’s hidden as no data in previous month's sheet, below the already filled ones from the previous month, the characters typed can’t be seen until after ‘Enter’ has been pressed, 'invisible' typing.
I presume this is due to the Conditional Formatting and that any characters typed will be ‘considered’ as ‘0’ until Enter is pressed.
Not being able to see what is being typed into the cell is a bit of an issue, although I realise I could check the box at the top. Is there a way to overcome this ‘invisible’ entry of text, please?
As always, I’m very grateful for any help or advice
Many thanks
%
I have cells which contain formula to copy data from equivalent cell on previous sheet, ie in February C26 sheet, it will show the data in January C26 sheet.
Consequently, I had a column of ‘0’ which I didn’t want showing, so used Conditional Formatting to set ‘If C26 = 0, then font colour same as background’ for the whole column
This works very well in that it hides the ‘0’s.
However, when data is entered into the ‘empty’ cells, ie those with the ‘0’s hidden as no data in previous month's sheet, below the already filled ones from the previous month, the characters typed can’t be seen until after ‘Enter’ has been pressed, 'invisible' typing.
I presume this is due to the Conditional Formatting and that any characters typed will be ‘considered’ as ‘0’ until Enter is pressed.
Not being able to see what is being typed into the cell is a bit of an issue, although I realise I could check the box at the top. Is there a way to overcome this ‘invisible’ entry of text, please?
As always, I’m very grateful for any help or advice
Many thanks
%