+ Reply to Thread
Results 1 to 3 of 3

color cells when criteria is met

  1. #1
    Cor
    Guest

    color cells when criteria is met

    Can i color a cell in Excel when the criteria is met.
    e.g. when a value is -1 i want to color it red automatically.

    Cor

  2. #2
    Peo Sjoblom
    Guest

    Re: color cells when criteria is met

    Format>conditional formatting, cell value is

    Regards,

    Peo Sjoblom

    "Cor" <[email protected]> wrote in message
    news:[email protected]...
    > Can i color a cell in Excel when the criteria is met.
    > e.g. when a value is -1 i want to color it red automatically.
    >
    > Cor




  3. #3
    Nick Hodge
    Guest

    Re: color cells when criteria is met

    Cor

    In Excel 97 up, check out conditional formatting

    Format>Conditional Formatting

    'Cell Value is' 'equal to' -1

    --
    HTH
    Nick Hodge
    Microsoft MVP - Excel
    Southampton, England
    [email protected]HIS


    "Cor" <[email protected]> wrote in message
    news:[email protected]...
    > Can i color a cell in Excel when the criteria is met.
    > e.g. when a value is -1 i want to color it red automatically.
    >
    > Cor




+ 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