Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    TN
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formatting - Borders (Excel 97)

    I'm trying to use conditional formatting to put double line borders under my total rows but notice that the available borders in conditional formatting are less extensive than those in typical cell formatting. Is there a way to get access to the double line borders when using conditional formatting. Thanks.

    Alan

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Conditional Formatting - Borders (Excel 97)

    The only way, using conditional formatting, that I know of is to add the double border explictly to all the cells in the range of interest.

    Then use conditional formatting to remove them when you don't want them on. They will be on when you do.

    Steve

  3. #3
    New Lounger
    Join Date
    Mar 2002
    Location
    TN
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting - Borders (Excel 97)

    Thanks, Steve. I don't believe I would have thought of that workaround. Are there any ideas as to why the available borders in conditional formatting are so limited?

    Alan

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Conditional Formatting - Borders (Excel 97)

    MS Excel programmer "laziness"? <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

    Steve

Posting Permissions

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