+ Reply to Thread
Results 1 to 4 of 4

Retaining the color of the border

  1. #1
    Registered User
    Join Date
    03-23-2022
    Location
    Bahamas
    MS-Off Ver
    2010
    Posts
    3

    Retaining the color of the border

    Hello,
    on performing the following steps in Excel 2010:
    • select A1 and A2
    • click the arrow next to Fill Color Button image or right click
    • under Theme Colors or Standard Colors, click red

    the color of A1 and A2 is changed to red, but the color of the border line between A1 and A2 is also changed to red.

    How can the colors of the 2 cells be changed retaining the gray color of the border line?

    Thank you, Tigogel

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,671

    Re: Retaining the color of the border

    I feel as if you are talking about the grid lines rather than borders.
    If you select cells A1:A2 and then select More Borders (Home tab > Font pane) you can select a border to be placed between A1:A2 and the border color.
    If you then change the fill color to red, the borders will remain the color that you previously chose.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    03-23-2022
    Location
    Bahamas
    MS-Off Ver
    2010
    Posts
    3

    Red face Re: Retaining the color of the border

    Thank you for your help!

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,671

    Re: Retaining the color of the border

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Workbook Border Color
    By xjohnson in forum Excel General
    Replies: 1
    Last Post: 10-29-2018, 04:35 PM
  2. Outside border change color
    By DanS52 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-14-2017, 12:55 PM
  3. [SOLVED] Click oval option button to fill/unfill color, also change border color to match fill
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2015, 08:29 PM
  4. [SOLVED] Border until reach another color
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2015, 01:12 PM
  5. Retaining border fonts
    By MinnesotaSelect in forum Excel General
    Replies: 2
    Last Post: 12-01-2008, 03:51 PM
  6. Replies: 3
    Last Post: 11-02-2005, 07:55 PM
  7. Replies: 1
    Last Post: 10-28-2005, 12:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1