Results 1 to 3 of 3
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    New York, New York, USA
    Thanked 0 Times in 0 Posts

    Cell Formatting (XP)

    Hi All,

    I have a grid of numbers (see attached) and I want to hi-light some numbers. In the attached example, I have put a box around them and also made them [/i]italics[/i] (that doesn't sound right - italized them?).

    Anyway, it is still unclear what numbers are hi-lighted (see 963 for example). So, what I am looking for is some way of formatting the number so that it stands out. Maybe a box around the number but inside the cell (ie not on the border of the cell).

    Restrictions:<UL><LI>colour coding will not work because it has to print in B&W
    <LI>shading will not work as it has to be photocoped
    <LI>the formatting has to be cell related so putting another object over it (ie autoshape) might not work and I have some macros that perform calculations depending on the formatting of the cell[/list]Any suggestions?
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Cape Town, RSA
    Thanked 1 Time in 1 Post

    Re: Cell Formatting (XP)

    It seems like you are after some type of box formatting, as I could simply suggest that you bold and underline the values???? Will that not suffice?

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Cell Formatting (XP)

    Not much you can do within the restrictions. Making the text bold might help. Using a larger font size will certainly make the numbers stand out, but the row size will increase.

    In the screenshot, the cells have been formatted as bold, 12 points, vertical aligment centered, and row height has been reset to standard.

Posting Permissions

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