Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formating

    <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>
    Excel 2000

    I know this should be simple...but I'm stuck.

    I would like the font color of A44 to change if the value in M44 is greater than 0, otherwise, I don't want the font color to change.

    Can someone please help me?
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Conditional Formating

    It's simple but not obvious.

    What you do is select A44, goto Format, Conditional Formatting and the in the consequent dialog change the dropdown Cell Value Is to Formula Is. Then enter =M44 > 0, in the space provided. Then click the format button and set the font color to the value you want when the condition is true.

    That should do it for you.

    Andrew C

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formating

    Andrew,

    Thanks for your help...it works perfectly....
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

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