Forum Widgets
Latest Discussions
Referenced cells do not identify themselves with color
For some reason when I create a formula that references other cells, I cannot get those cells to "identify" themselves with a specific color. For example, in the image below the formula references cells B7, B8, B6, etc but they are just black text and don't show up in color per standard excel documents. Usually they "glow" with a specific color so you can find them easily in big spreadsheets. How do I get the colors back?
Excel Protected Sheet: Cells Still Editable Even Though They Aren’t in the Unlocked Range
I’m having an issue with sheet protection in Excel where certain cells remain editable even though they are not included in any of my configured Unlocked Ranges. I have sheet protection enabled and have specifically configured the following ranges as editable: A:E G:G J:J P:BE Based on that configuration, I would expect columns F, H:I, and K:O to be protected. However, the behavior is inconsistent: Column F/G is correctly locked and cannot be edited. Columns K:O can still be edited, despite not being included in any of the Unlocked Ranges. I’m trying to understand why F/G are respecting the protection as expected while K:O remain editable under seemingly the same protection configuration.
