+ Reply to Thread
Results 1 to 5 of 5

[SOLVED] conditional format text - please help!

  1. #1
    Vivek
    Guest

    [SOLVED] conditional format text - please help!

    If I have one cell - d32, and when the value becomes negative I want cell E32
    to say "Over Budget", would this be possible?

  2. #2
    George Gee
    Guest

    Re: conditional format text - please help!

    Not entirely sure what you are asking... but see if this helps.
    In E32 =IF(D32<0,"Over Budget","")

    George Gee

    "Vivek" <Vivek@discussions.microsoft.com> wrote in message
    news:7303B46C-AD91-428A-8B87-D9542F899C50@microsoft.com...
    > If I have one cell - d32, and when the value becomes negative I want cell
    > E32
    > to say "Over Budget", would this be possible?




  3. #3
    Vivek
    Guest

    Re: conditional format text - please help!

    It works, thanks a lot! I also want to do the same thing when D32 is
    positive with the same cell. How do you do this?

    "George Gee" wrote:

    > Not entirely sure what you are asking... but see if this helps.
    > In E32 =IF(D32<0,"Over Budget","")
    >
    > George Gee
    >
    > "Vivek" <Vivek@discussions.microsoft.com> wrote in message
    > news:7303B46C-AD91-428A-8B87-D9542F899C50@microsoft.com...
    > > If I have one cell - d32, and when the value becomes negative I want cell
    > > E32
    > > to say "Over Budget", would this be possible?

    >
    >
    >


  4. #4
    George Gee
    Guest

    Re: conditional format text - please help!



    In E32 =IF(D32<0,"Over budget","On Target")

    Change the text *On Target* to whatever you wish to appear.
    Is this what you want, if not, post back with more details.

    George Gee





    "Vivek" <Vivek@discussions.microsoft.com> wrote in message
    news:4FEB5587-D207-42AC-BC7D-AA9F17603FE3@microsoft.com...
    > It works, thanks a lot! I also want to do the same thing when D32 is
    > positive with the same cell. How do you do this?
    >
    > "George Gee" wrote:
    >
    >> Not entirely sure what you are asking... but see if this helps.
    >> In E32 =IF(D32<0,"Over Budget","")
    >>
    >> George Gee
    >>
    >> "Vivek" <Vivek@discussions.microsoft.com> wrote in message
    >> news:7303B46C-AD91-428A-8B87-D9542F899C50@microsoft.com...
    >> > If I have one cell - d32, and when the value becomes negative I want
    >> > cell
    >> > E32
    >> > to say "Over Budget", would this be possible?

    >>
    >>
    >>




  5. #5
    Vivek
    Guest

    Re: conditional format text - please help!

    Thanks so much, it works!!!

    "George Gee" wrote:

    >
    >
    > In E32 =IF(D32<0,"Over budget","On Target")
    >
    > Change the text *On Target* to whatever you wish to appear.
    > Is this what you want, if not, post back with more details.
    >
    > George Gee
    >
    >
    >
    >
    >
    > "Vivek" <Vivek@discussions.microsoft.com> wrote in message
    > news:4FEB5587-D207-42AC-BC7D-AA9F17603FE3@microsoft.com...
    > > It works, thanks a lot! I also want to do the same thing when D32 is
    > > positive with the same cell. How do you do this?
    > >
    > > "George Gee" wrote:
    > >
    > >> Not entirely sure what you are asking... but see if this helps.
    > >> In E32 =IF(D32<0,"Over Budget","")
    > >>
    > >> George Gee
    > >>
    > >> "Vivek" <Vivek@discussions.microsoft.com> wrote in message
    > >> news:7303B46C-AD91-428A-8B87-D9542F899C50@microsoft.com...
    > >> > If I have one cell - d32, and when the value becomes negative I want
    > >> > cell
    > >> > E32
    > >> > to say "Over Budget", would this be possible?
    > >>
    > >>
    > >>

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1