Jun 19 2020 01:08 PM
I inadvertantly did something such that whenever I attempt to enter data in a cell the cell background turns black and I cannot see what I'm typing. How do I get back to "normal"?
Jun 19 2020 01:26 PM
Hi @whs15116gmailcom ,
Check your conditional Formatting. You may have a rule that changes the background to black when any data is present in the cell.
Select the cell > Conditional Formatting > Clear Rules... > Clear Rules from Selected Cell
Ben
Jun 19 2020 02:48 PM
@Bennadeau Thanks for your help> I tried your suggestion, alas to no avail. I've been doing spreadsheets since they first came out and I've never seen this happen. Went back to an earlier version and it was fine. Lost data was not important. Best regards, Bill
Jun 19 2020 03:02 PM
I got to say now I'm curious.
Can you send the old spreadsheet, obviously redact any confidential data. I want to see if it will act the same on my end.
Also, please specify which OS and Excel version you are using.
Ben
Jun 19 2020 03:31 PM