How to change grid line colors?

[Eloise T]

How do you change even just a single cell or small range of cells gridline color WITHOUT going to Excel → OPTIONS → Advanced → Display Options for this worksheet → Gridline color which changes the whole enchilada?

...and without the use of a macro.

I have been looking most of the day, off and on, and within a few minutes of posting the question, I found it...

I hope some else may benefit.

Thank goodness it's Friday.

 

[bobhc]

As you are occupied with your enchilada, cant beat a good pork pie packed with trotter jelly and smeared in good strong yellow English mustard, you could try the key board method, much quicker, oops nearly for got the pickled eggs and pickled onions and a pint or two of ice cold beer.

ctr+1 gets you:-


.

 

[Eloise T]

Good to know re: Ctrl + 1

So where is the best place to get a good pork pie packed with trotter jelly and smeared in good strong yellow English mustard, not to forget the pickled eggs, pickled onions, and a pint ice cold beer?

 

[bobhc]

Lincolnshire

 

[Eloise T]

Precisely where in Lincolnshire...which pub?

 

[bobhc]

Any pub. If they do not serve this delicacy then they do not deserve patrons of taste

 

[Eloise T]

Duly noted.

I know, but have you investigated the making of trotter jelly?

 

[bobhc]

but have you investigated the making of trotter jelly?

I make it myself.

 

[Eloise T]

How long does it take to make a jar?
I know it's a long time...hours...?

 

[Pete Mccann]

I'm running the risk of enraging an Excel Ninja in this reply (and potentially getting banned from what is arguably the best source of Excel knowledge in the universe) ......but surely the home of the pork pie is Melton Mowbray in Leicestershire. As for the accompaniments that are mentioned, they cannot be beaten.

 

[Eloise T]

 

[AliGW]

Good to know re: Ctrl + 1

So where is the best place to get a good pork pie packed with trotter jelly and smeared in good strong yellow English mustard, not to forget the pickled eggs, pickled onions, and a pint ice cold beer?

No, not an ice cold beer - more like a pint of real ale at cellar temperature.

 

[Eloise T]

That's the spirit(s).