ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Lightened gridlines, now borders are that color now, even though (https://www.excelbanter.com/setting-up-configuration-excel/40244-lightened-gridlines-now-borders-color-now-even-though.html)

Kendall

Lightened gridlines, now borders are that color now, even though
 
I changed the border color from "automatic" to black. I lightened the
gridlines because I still want to be able to see them, but the black thin
borders don't show up on the regular-color gridlines.

Now, it seems the problem is worse than before I changed anything.
(Remember, I DID change the border color to black from automatic.)

Any ideas?

Monte

I prefer the lighter gridlines too (ToolsOptionsView tab) Grey-25%. It
helps the data stand out better.

If you've already got the gridlines of the unused cells changed to the
lighter color, go back (FormatCellsBorder tab), turn off and back on the
borders and "ok" the cells you want darker.

If that doesn't work, you may have Conditional Formats assigned to the cells
that are acting up. Select those cells, open the Conditional Formatting
window (FormatConditional Formatting) and delete the conditions.


"Kendall" wrote:

I changed the border color from "automatic" to black. I lightened the
gridlines because I still want to be able to see them, but the black thin
borders don't show up on the regular-color gridlines.

Now, it seems the problem is worse than before I changed anything.
(Remember, I DID change the border color to black from automatic.)

Any ideas?


All times are GMT +1. The time now is 08:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com