Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: Changing the color of the little triangle on cells with comm

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Michigan, USA
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    I set the cells' background color to red, and generated a comment. Due to the little triangle being red too, the triangle is invisible (since the background is red). Could you teach me how to change the triangle's color to another color, i.e. white or yellow?

    Thank you very much.

    ssunchen

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sure can,

    The comment triangle comes in two colours though. Fire Engine Red and Strathclyde Red. To the naked eye, the former is the colour of the comment triangle. The latter is a tinge more tangerine than red, but again to the naked eye, it appears red. To change the colour, you open Excel, then do absolutely nothing.

    I sincerely hope that this helps.

    PS. It's not possible, change your background colour to green for the attribure clash. Sorry, a couple of pitchers of beer for the worse.

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-24 21:40, Mark O'Brien wrote:
    Sure can,

    The comment triangle comes in two colours though. Fire Engine Red and Strathclyde Red. To the naked eye, the former is the colour of the comment triangle. The latter is a tinge more tangerine than red, but again to the naked eye, it appears red. To change the colour, you open Excel, then do absolutely nothing.

    I sincerely hope that this helps.

    PS. It's not possible, change your background colour to green for the attribure clash. Sorry, a couple of pitchers of beer for the worse.
    Hi Mark:
    As I saw your posting, I was wondering where you were going with it ... although the analogy seemed quite obvious -- sure you can get it in any color you want as long as it is black!

  4. #4
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yup, just as Henry T Ford said.

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi guys

    i have little green triangle if you rintrested!


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  6. #6
    Board Regular swaink's Avatar
    Join Date
    Feb 2002
    Location
    51.421818,-0.977139
    Posts
    432
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    HI Jack

    Im interested Mate

    Regards

    Kev

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Very soory i was monkeying about since i ahve gone XP Excle i have little red tirangles just as you but the other top corner has green its EXCEL XP trying to be helpful has drop down to crooect errors, best bit is converts labled numbers to true numbers easy,

    My point was i have TRIANGLED to solve this i want to move the and re colour them and re size them, even have little LOGO

    NOPE

    Maybe so one knows how!!


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  8. #8
    Board Regular
    Join Date
    May 2002
    Posts
    810
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Since the thread's topic has been dealt with, how about helping me with another extremely critical detail of Excel?


    I am an under-achiever, and proud of it. I really try hard not to push myself.

    Unfortunately, I am obligated to use Excel, the name is a shortening of the word excellent, and which, in itself, connotes a striving for superiority.

    Is there any way to change the name of the program to something less elitest, less proud, something that doesn't connotate a constant endeavor for superior results?

    Quattro is a good means-nothing word, but, unfortunately, my company doesn't use it.


    Just wondering,
    Steve

  9. #9
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Yes you can change some ID to Excel like the splash screed IE not have one or change it, to a picture of JACK!!!

    Also the Excel workbook in the top left can be edited to JACK IN THE UK!!!

    Does this help

    Search for these on this boar i have posted address to this before

    HTH

    Jack

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  10. #10
    Board Regular
    Join Date
    Jun 2002
    Location
    Canada
    Posts
    151
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I found this on Google that might interest you. It does not change the color of the comment but it puts a mask over top of the comment indicator. Don't know why you would want a Red background anyway isn't that a little hard on the eyes?

    Any take a look,

    http://groups.google.ca/groups?q=com....ac.uk&rnum=13

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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