Conditional formatting - Can't change border color

Question

Hello Microsoft community,

 I was setting-up some conditional formatting on a spreadsheet in EXCEL 365. Everything works fine except for the border color: I can't change it from automatic to other colors. Whenever I change the color in the cell format dialog box, it keeps turning black (see below pictures)

 I don't know if this is a bug or I'm doing something wrong. Can someone help out here please?

Thank you,

Answer 1

When you click on the format button, and change the colour, then click ok, does it reset itself to a black color? if it does it could possibly be a bug with your excel.

Answer 2

Hi Ahmed,

From the description provided, when we tested at our end in the latest version of different Office channels, we can reproduce the behavior as your described in your post. However, after testing with multiple colors for fill, we can’t reproduce the behavior for the color below when we select it as fill color:

We do understand the inconvenience caused by the problem and sorry for it. We request you provide the feedback via Excel application as related developing team will notice it.

Open the Excel application> Feedback> I Don’t Like Something> Provide the description and submit it.

Appreciate your patience and understanding.

Regards,

Chitrahaas

Answer 3

Thank you all for the replies, I'll submit the bug in Excel feedback platform

Answer 4

To:  ahmed

re:  condtional formatting of borders

Shown below are notes, to myself, on Excel cell borders from 2006 (13 years ago).

I don't believe anything has changed.

Those with an interest, should read thru the entire note...

'---

June 12, 2006

Notes on Excel Borders and Colors...

There are 8 regular borders for a cell.

   Constants 5 thru 12...

   Constants 7, 8, 9, 10 are the cell edges.

   (xlEdgeLeft, xlEdgeTop, xlEdgeBottom, xlEdgeRight)

   Constants 5, 6, 11, 12 are interior borders that are unique to a cell.

There are 4 regular border weights (widths) for a cell.

   Constants 1, 2, -4138, 4

   (xlHairline, xlThin, xlMedium, xlThick)

   Note:  a blank cell, with no borders, has a border weight of 2.

There are 7 regular border linestyles for a cell

   Constants 1, -4115, 4, 5, -4118, -4119, 13

   (xlContinuous, xlDash, xlDashdot, xlDashdotdot, xlDot, xlDouble, xlSlantdashdot)

There are 4 CF borders for a cell.

   Constants -4131, - 4160, - 4107, - 4152

   (xlLeft, xlTop, xlBottom, xlRight)

   These are equivalent to constants 7, 8, 9, 10 for regular borders.

There are 2 CF border weights (widths) for a cell.

   Constants 1, 2 (xlHairline, xlThin)

There are 5 CF border linestyles for a cell.

   Constants 1, -4115, 4, 5, - 4118

   (xlContinuous, xlDash, xlDashdot, xlDashdotdot, xlDot)

   - Shown in PRIORITY ORDER -

   All CF linestyles, except xlDot, have a fixed weight of 2.

   The xlDot linestyle weight is 1.

Borders between adjoining cells are a common border, with some exceptions.

Excel keeps track of the cell from which the border was applied.

(the owner cell for the border)

CF borders always override any regular borders in a cell as long as the

   regular borders originated in that cell.

CF borders override adjoining cell CF borders/regular borders if the

   active cell CF border is wider than the other border - or -

   if the same width but has a higher priority linestyle.

If active cell CF borders are the same (width and linestyle) as the adjoining CF/regular

   borders then the dominant color is visible.

   The dominant color is difficult to determine.

If active cell CF borders are narrower than the adjoining borders  - or -

   if the same width, but have a lower priority linestyle, then the adjoining cell,

   CF/regular borders are displayed.

'---

My conclusion:  don't bother using CF on borders.

Some new, some older Excel programs (now free) at MediaFire...

Download from... http://www.mediafire.com/folder/lto3hbhyq0hcf/Documents

Answer 5

To:  ahmed

re:  condtional formatting of borders

Shown below are notes, to myself, on Excel cell borders from 2006 (13 years ago).

I don't believe anything has changed.

Those with an interest, should read thru the entire note...

'---

June 12, 2006

Notes on Excel Borders and Colors...

There are 8 regular borders for a cell.

   Constants 5 thru 12...

   Constants 7, 8, 9, 10 are the cell edges.

   (xlEdgeLeft, xlEdgeTop, xlEdgeBottom, xlEdgeRight)

   Constants 5, 6, 11, 12 are interior borders that are unique to a cell.

There are 4 regular border weights (widths) for a cell.

   Constants 1, 2, -4138, 4

   (xlHairline, xlThin, xlMedium, xlThick)

   Note:  a blank cell, with no borders, has a border weight of 2.

There are 7 regular border linestyles for a cell

   Constants 1, -4115, 4, 5, -4118, -4119, 13

   (xlContinuous, xlDash, xlDashdot, xlDashdotdot, xlDot, xlDouble, xlSlantdashdot)

There are 4 CF borders for a cell.

   Constants -4131, - 4160, - 4107, - 4152

   (xlLeft, xlTop, xlBottom, xlRight)

   These are equivalent to constants 7, 8, 9, 10 for regular borders.

There are 2 CF border weights (widths) for a cell.

   Constants 1, 2 (xlHairline, xlThin)

There are 5 CF border linestyles for a cell.

   Constants 1, -4115, 4, 5, - 4118

   (xlContinuous, xlDash, xlDashdot, xlDashdotdot, xlDot)

   - Shown in PRIORITY ORDER -

   All CF linestyles, except xlDot, have a fixed weight of 2.

   The xlDot linestyle weight is 1.

Borders between adjoining cells are a common border, with some exceptions.

Excel keeps track of the cell from which the border was applied.

(the owner cell for the border)

CF borders always override any regular borders in a cell as long as the

   regular borders originated in that cell.

CF borders override adjoining cell CF borders/regular borders if the

   active cell CF border is wider than the other border - or -

   if the same width but has a higher priority linestyle.

If active cell CF borders are the same (width and linestyle) as the adjoining CF/regular

   borders then the dominant color is visible.

   The dominant color is difficult to determine.

If active cell CF borders are narrower than the adjoining borders  - or -

   if the same width, but have a lower priority linestyle, then the adjoining cell,

   CF/regular borders are displayed.

'---

My conclusion:  don't bother using CF on borders.

Some new, some older Excel programs (now free) at MediaFire...

Download from... http://www.mediafire.com/folder/lto3hbhyq0hcf/Documents

Thank you for your reply. 

As you said, the borders are commun between two cells, which, I guess, confuses Excel when using a complicated conditional formatting. I think I will try to overturn this bug with a VBA code