Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default changing colour of cell border

this should be really easy, but I just can't workout how to do it. I have
selected a few cells and made the border thick. I now want to change the
colour of the border (but only this border) - but can't figure it out...?

Any ideas?

cheers

j.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 43
Default changing colour of cell border

Hi,

You can change the border color as follows:

Select the cells -- Format -- Cells -- Border (Tab) -- Color.

Regards,
Soundar.

"jacobite" wrote:

this should be really easy, but I just can't workout how to do it. I have
selected a few cells and made the border thick. I now want to change the
colour of the border (but only this border) - but can't figure it out...?

Any ideas?

cheers

j.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default changing colour of cell border

Hi Soundar

I tried that... but it doesn't appear to work... very strange. Seems to
default to black.

d.

"Soundar" wrote:

Hi,

You can change the border color as follows:

Select the cells -- Format -- Cells -- Border (Tab) -- Color.

Regards,
Soundar.

"jacobite" wrote:

this should be really easy, but I just can't workout how to do it. I have
selected a few cells and made the border thick. I now want to change the
colour of the border (but only this border) - but can't figure it out...?

Any ideas?

cheers

j.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default changing colour of cell border

Hi,

Once you change the color, you need to re-select the border you want for the
new colour to show up, don't know why changing the colour just doesn't change
the border when you click ok, but there you go :)

stevefromnaki :)

"jacobite" wrote:

Hi Soundar

I tried that... but it doesn't appear to work... very strange. Seems to
default to black.

d.

"Soundar" wrote:

Hi,

You can change the border color as follows:

Select the cells -- Format -- Cells -- Border (Tab) -- Color.

Regards,
Soundar.

"jacobite" wrote:

this should be really easy, but I just can't workout how to do it. I have
selected a few cells and made the border thick. I now want to change the
colour of the border (but only this border) - but can't figure it out...?

Any ideas?

cheers

j.

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default changing colour of cell border

A tiny trick is needed.

1. Select cells
2. Pull down:
Format Cells... Border
3. Pick the color

notice all the Styles change color!!

4. then apply the border


You can not apply borders first and then apply the color.
--
Gary''s Student - gsnu200757


"jacobite" wrote:

Hi Soundar

I tried that... but it doesn't appear to work... very strange. Seems to
default to black.

d.

"Soundar" wrote:

Hi,

You can change the border color as follows:

Select the cells -- Format -- Cells -- Border (Tab) -- Color.

Regards,
Soundar.

"jacobite" wrote:

this should be really easy, but I just can't workout how to do it. I have
selected a few cells and made the border thick. I now want to change the
colour of the border (but only this border) - but can't figure it out...?

Any ideas?

cheers

j.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing Cell Contents Colour Spiller Excel Discussion (Misc queries) 3 November 24th 06 01:40 PM
Changing a cell colour fatdave Excel Discussion (Misc queries) 2 November 9th 06 08:44 AM
Default Cell border colour? Tibbs Excel Discussion (Misc queries) 0 June 27th 06 09:40 AM
On a Mac how do I change the border colour of the active cell? Lino Excel Discussion (Misc queries) 2 May 23rd 06 01:36 PM
Changing the border of one cell s/n change the border of adjacent gjanssenmn Excel Discussion (Misc queries) 2 October 5th 05 08:35 PM


All times are GMT +1. The time now is 07:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"