Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Mar 2005
    Location
    London, Hampshire, United Kingdom
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    BORDER OF A CELL (2007)

    How can I change its colour? Every time I try to it reverts to the automatic black. I do not want to change the automatic colour (not that I know how to) because black suits me for most of the cells; but there are some where I want a blue border. This problem arose in conditional formatting but applies to ordinary formatting too. It occurs in 2007 and 2003.

    Any ideas?

  2. #2
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: BORDER OF A CELL (2007)

    Hi Andrew

    Right click the cell or range of cells and select the 'Format Cells' option, then select the 'Borders' tab, on the right bottom of the screen select the colour and then click on the border type, outside or inside borders or both and click OK.

    HTH

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  3. #3
    Star Lounger
    Join Date
    Mar 2005
    Location
    London, Hampshire, United Kingdom
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: BORDER OF A CELL (2007)

    That is what is not working - it reverts to Automatic!

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: BORDER OF A CELL (2007)

    Are you certain that all Conditional Formatting has been removed? Select a problem cell, select Formatting | Conditional and see any conditions are in force. If so, see what kind of formatting is being applied.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Star Lounger
    Join Date
    Mar 2005
    Location
    London, Hampshire, United Kingdom
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: BORDER OF A CELL (2007)

    Somebody has cracked it for me. You have to select the colour before you choose which sides you want a border on. If you do it the other way round it won't work. It's obvious . . . or rather it isn't. But now I know. Thanks, all.

Posting Permissions

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