+ Reply to Thread
Results 1 to 13 of 13

How to change column and row headlines colors

  1. #1
    Registered User
    Join Date
    10-20-2021
    Location
    Poland
    MS-Off Ver
    365
    Posts
    5

    How to change column and row headlines colors

    Hi,

    I am searching for advice how to change column and row headlines colors like shown od the picture.


    excel headlines.jpg

    Any advice?

    thx,

    fructo

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,323

    Re: How to change column and row headlines colors

    Welcome to the forum.

    Based purely on what we know from your post, select cells B1 and C1, then apply a colour using the Fill tool on the Home ribbon (it looks like a paint can).
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: How to change column and row headlines colors

    Do you want to highlight (change colour) on row 1 for column as selected cell?
    Or do you mean how to change background of cells manually?

    <PL lang=ON>kompletnie nie rozumiem</PL lang=OFF>
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  4. #4
    Registered User
    Join Date
    10-20-2021
    Location
    Poland
    MS-Off Ver
    365
    Posts
    5

    Re: How to change column and row headlines colors

    sorry for not being clear.
    So in my Excel (attached picture) I can see this grey headlines (and by headlines I understand naming for rows: 1,2,3,4, and columns A,B,C,D...)
    In example shown before they are colored in dark grey (and this yellow selecion is nicly contrasting).
    In opposite to this light grey and highlits of headlines (green for column A and darker grey for row 1)of the selected cell, which are not so visible in default excel look(especially in bigger data sets).
    Hope this will clarify my intent

    excel headlines 2.jpg

  5. #5
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: How to change column and row headlines colors

    Something like this:

    Capture.PNG
    Attached Files Attached Files
    Last edited by KOKOSEK; 10-21-2021 at 11:37 AM.

  6. #6
    Registered User
    Join Date
    10-20-2021
    Location
    Poland
    MS-Off Ver
    365
    Posts
    5

    Re: How to change column and row headlines colors

    Asking question is not an easy task
    Ok. I will try to clarify with this pic.
    I know how to fill colors in cels, columns, rows etc. I don't know how to change the color of headlines.
    Thank you!

    Attachment 752672

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,323

    Re: How to change column and row headlines colors

    You can't change that, as far as I am aware

  8. #8
    Registered User
    Join Date
    10-20-2021
    Location
    Poland
    MS-Off Ver
    365
    Posts
    5

    Re: How to change column and row headlines colors

    I took the screenshot from this video on youtube called
    "Alternating Row and Column Colors and Other Formatting Options in Excel"
    (I cannot paste the link to it).
    So how come someone has managed that?
    Is it contrast setting in windows then?

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,323

    Re: How to change column and row headlines colors

    You really haven't been clear at all!

    I was looking at the column and header labels.

    Yes, what you want (alternate shading of the rows) can be done with conditional formatting.

    There are instructions at the top of the page explaining how to attach your sample workbook.

  10. #10
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: How to change column and row headlines colors

    Do you mean changing colour of these:

    1.PNG

  11. #11
    Registered User
    Join Date
    10-22-2021
    Location
    Devon, UK
    MS-Off Ver
    Office 365
    Posts
    8

    Re: How to change column and row headlines colors

    Last edited by AliGW; 10-22-2021 at 07:08 AM. Reason: Mod made link live.

  12. #12
    Registered User
    Join Date
    10-20-2021
    Location
    Poland
    MS-Off Ver
    365
    Posts
    5

    Re: How to change column and row headlines colors

    Sorry. I failed explaining that.
    Thanks everyone.
    It seems it is not doable. The only option is changing Office Theme to Dark Grey.
    Not exactly what I had in mind, but will have to do.

    Best!
    Last edited by fructo; 10-22-2021 at 11:26 AM.

  13. #13
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,323

    Re: How to change column and row headlines colors

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

+ 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] VBA code to change Excel chart bar colors as per cell colors
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-21-2016, 03:29 AM
  2. Replies: 9
    Last Post: 07-05-2012, 04:41 PM
  3. Replies: 12
    Last Post: 06-18-2012, 08:26 AM
  4. Change default colors for column chart?
    By handerson0603 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-03-2012, 03:39 PM
  5. Replies: 4
    Last Post: 04-13-2011, 11:51 AM
  6. Change font colors from Column A, checking Column G
    By Marco-Kun in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2009, 09:08 AM
  7. Replies: 41
    Last Post: 04-10-2009, 08:50 AM

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