ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   changing colour of cell border (https://www.excelbanter.com/excel-discussion-misc-queries/166721-changing-colour-cell-border.html)

jacobite

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.

Soundar

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.


jacobite

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.


stevefromnaki

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.


Gary''s Student

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.



All times are GMT +1. The time now is 04:30 AM.

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