Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2003
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can you change font properties in a function? (Exel 2000 SR-1)

    Hi All,

    Below you'll see a function formula I have in one of my Excel files:

    =IF(B$20>=3,T("Assigned"),T("Available" ))

    My question is, is there anyway possible to modify this IF statement to included changing font color, or font face (i.e. bold, italics) depending on whether the formula returns True or False. Below is an example of what I mean:

    IF(B$20>=3,(T("Assigned") AND (FontColor="Red")),(T("Available" ) AND (FontColor="Black")))

    I've tried many different iterations of the above formula, to include entering the hex color codes, but to no avail.

    I guess first question is, am I trying do something that isn't possible in a formula? If this is possible to do, could someone please help me with the syntax?

    Any tips would be greatly appreciated.

    Thanks,

    DG

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can you change font properties in a function? (Exel 2000 SR-1)

    No, you can't do that in a formula.

    Have you tried Conditional Formatting?
    - Select the cell(s) you want to format.
    - Select Format | Conditional Formatting...
    - Select Formula Is from the dropdown list.
    - Enter =(B$20>=3) in the box next to it.
    - Click the Format... button.
    - Set font color to red.
    - Click OK (twice)

  3. #3
    New Lounger
    Join Date
    Sep 2003
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can you change font properties in a function? (Exel 2000 SR-1)

    Hans,

    Thanks for steering me in the right direction. That's exactly what I needed.

    Regards,

    DG

Posting Permissions

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