Text is white in some cells

[Wally3178]

Hi,

I have created an Excel sheet for the recording of collected weather data
but I am getting frustrated by the non appearance of data in just three
cells. If I put in a background colour I can see the data in white so
obviously the font has become set in these cells to white but in the format
cells I have black set as the font. I could understand if it was all the
cells in the sheet but its only three out of about 1000.

Does anyone have any ideas about how I troubleshoot this issue? I have
searched the knowledgebase and this forum for answers but found nothing that
helps me.

Cheers

 

[Pranav Vaidya]

Hi,

I think the probnelm is with format of the cell. You can check the
formatting of this cell, if it is Custom change it to number.
Also check if there is any conditional formatting pre-set for these cells.

HTH,

 

[Wally3178]

Thanks for that, it worked.

Cheers,

--
Wal

Hi,

I think the probnelm is with format of the cell. You can check the
formatting of this cell, if it is Custom change it to number.
Also check if there is any conditional formatting pre-set for these cells.

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!