+ Reply to Thread
Results 1 to 7 of 7

IF statements if the value is True it changes the cell colour?

  1. #1
    Peo Sjoblom
    Guest

    Re: IF statements if the value is True it changes the cell colour?

    No need for if statements,

    =A>1

    as opposed to =IF(A1>1

    look up conditional formatting in help

    --
    Regards,

    Peo Sjoblom

    (No private emails please)


    "J. Kerr" <J. [email protected]> wrote in message
    news:[email protected]...
    > Is there a way to change the colour of the cell when using an IF
    > statement.
    > ie: I would like to see the cell Green if it is TRUE and Red if it is
    > FALSE



  2. #2
    bj
    Guest

    RE: IF statements if the value is True it changes the cell colour?

    use <format><conditional format> formula is your if statement format green
    use your if statement with a NOT in front with format red

    "J. Kerr" wrote:

    > Is there a way to change the colour of the cell when using an IF statement.
    > ie: I would like to see the cell Green if it is TRUE and Red if it is FALSE


  3. #3
    David McRitchie
    Guest

    Re: IF statements if the value is True it changes the cell colour?

    The easiest way is to use Conditional Formatting
    Conditional Formatting
    http://www.mvps.org/dmcritchie/excel/condfmt.htm

    The formula used in Conditional Formatting is a worksheet formula
    and you want to think in terms of selecting an entire column rather
    than an individual cell at a time.


    select column C1 then column C, just so you have C1 as the active cell
    format, conditional formatting
    formula is: =C1>20 is going to be True (used) or False (ignored) errors are ignored
    format button, use patterns then chose color for interior

    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "J. Kerr" <J. [email protected]> wrote in message news:[email protected]...
    > Is there a way to change the colour of the cell when using an IF statement.
    > ie: I would like to see the cell Green if it is TRUE and Red if it is FALSE




  4. #4
    J. Kerr
    Guest

    IF statements if the value is True it changes the cell colour?

    Is there a way to change the colour of the cell when using an IF statement.
    ie: I would like to see the cell Green if it is TRUE and Red if it is FALSE

  5. #5
    Peo Sjoblom
    Guest

    Re: IF statements if the value is True it changes the cell colour?

    No need for if statements,

    =A>1

    as opposed to =IF(A1>1

    look up conditional formatting in help

    --
    Regards,

    Peo Sjoblom

    (No private emails please)


    "J. Kerr" <J. [email protected]> wrote in message
    news:[email protected]...
    > Is there a way to change the colour of the cell when using an IF
    > statement.
    > ie: I would like to see the cell Green if it is TRUE and Red if it is
    > FALSE



  6. #6
    bj
    Guest

    RE: IF statements if the value is True it changes the cell colour?

    use <format><conditional format> formula is your if statement format green
    use your if statement with a NOT in front with format red

    "J. Kerr" wrote:

    > Is there a way to change the colour of the cell when using an IF statement.
    > ie: I would like to see the cell Green if it is TRUE and Red if it is FALSE


  7. #7
    David McRitchie
    Guest

    Re: IF statements if the value is True it changes the cell colour?

    The easiest way is to use Conditional Formatting
    Conditional Formatting
    http://www.mvps.org/dmcritchie/excel/condfmt.htm

    The formula used in Conditional Formatting is a worksheet formula
    and you want to think in terms of selecting an entire column rather
    than an individual cell at a time.


    select column C1 then column C, just so you have C1 as the active cell
    format, conditional formatting
    formula is: =C1>20 is going to be True (used) or False (ignored) errors are ignored
    format button, use patterns then chose color for interior

    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "J. Kerr" <J. [email protected]> wrote in message news:[email protected]...
    > Is there a way to change the colour of the cell when using an IF statement.
    > ie: I would like to see the cell Green if it is TRUE and Red if it is FALSE




+ 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