Results 1 to 5 of 5

Thread: Font size formula

  1. #1

    Font size formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all,

    I have been CF for #n/a but cant since I have my desktop background
    changed into black colour and the words in grey. It wont cover the #n/a
    with black colour.

    Am wondering if there is a font size formula to reduce #n/a.

    =font(na(),1) something like this and when #n/a, it appear as small as possible.

    Thanks for any feedback.

  2. #2
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Location
    Askew
    Posts
    183
    Articles
    0
    Excel Version
    2010
    Can't you just handle the error in your formula so it doesn't appear in the first place? (or do you want it present, but small?)
    Circumference of a circle = 2πrē



    ēthe circle's radius

  3. #3
    Quote Originally Posted by JoePublic View Post
    Can't you just handle the error in your formula so it doesn't appear in the first place? (or do you want it present, but small?)
    If it's without change the desktop colour, it's done. To compensate it, I was thinking to reduce the font the smallest possible but the CF doesn't have that option.

    Any more idea?

  4. #4
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Location
    Askew
    Posts
    183
    Articles
    0
    Excel Version
    2010
    I have no idea what you mean. I'm not talking about colours, I'm suggesting changing your formulas so that they don't return errors at all.
    Circumference of a circle = 2πrē



    ēthe circle's radius

  5. #5
    Use the Conditional Formatting this way:

    New Formatting Rule
    Select a rule type:
    Format only cells that contain
    Edit the Rule description:
    Format only cells with:
    Select "Errors" from the drop down
    Press the "Format" button
    Choose "Colour", and then choose black

    Your #n/a will then appear in black text on the black bakground

Tags for this Thread

Posting Permissions

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