+ Reply to Thread
Results 1 to 6 of 6

Additional Conditions for Conditional Formatting

  1. #1
    David McRitchie
    Guest

    Re: Additional Conditions for Conditional Formatting

    Hi Eric,
    One way is to use a Change Event macro (not for formulas)
    http://www.mvps.org/dmcritchie/excel/event.htm#case

    The other way is t use an Addon that extends the number of conditions
    Extended Conditional Formatter «Excel addin«, Bob Phillips
    & Frank Kabel, addin that makes it possible to enter up to 50 conditions
    with the same entry type panels as builtin Conditional Formatting.
    Note this is Beta software (testing not production). (posted 2004-11-07)
    http://www.xldynamic.com/source/xld.....Download.html

    ---
    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

    "eric beck" <eric beck@discussions.microsoft.com> wrote in message news:64C22264-EFC5-4526-874D-81189914264B@microsoft.com...
    > I know that Excel 2000 will only allow you to have 3 Conditions for
    > Conditional Formatting, is there any way to get more?
    >
    > Not sure how many more will be needed but 3 isn't enough...
    >
    > could you notify me to this address: eric_beck05@hotmail.com
    >
    > Thanks




  2. #2
    David McRitchie
    Guest

    Re: Additional Conditions for Conditional Formatting

    Hi Eric,
    One way is to use a Change Event macro (not for formulas)
    http://www.mvps.org/dmcritchie/excel/event.htm#case

    The other way is t use an Addon that extends the number of conditions
    Extended Conditional Formatter «Excel addin«, Bob Phillips
    & Frank Kabel, addin that makes it possible to enter up to 50 conditions
    with the same entry type panels as builtin Conditional Formatting.
    Note this is Beta software (testing not production). (posted 2004-11-07)
    http://www.xldynamic.com/source/xld.....Download.html

    ---
    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

    "eric beck" <eric beck@discussions.microsoft.com> wrote in message news:64C22264-EFC5-4526-874D-81189914264B@microsoft.com...
    > I know that Excel 2000 will only allow you to have 3 Conditions for
    > Conditional Formatting, is there any way to get more?
    >
    > Not sure how many more will be needed but 3 isn't enough...
    >
    > could you notify me to this address: eric_beck05@hotmail.com
    >
    > Thanks




  3. #3
    David McRitchie
    Guest

    Re: Additional Conditions for Conditional Formatting

    Hi Eric,
    One way is to use a Change Event macro (not for formulas)
    http://www.mvps.org/dmcritchie/excel/event.htm#case

    The other way is t use an Addon that extends the number of conditions
    Extended Conditional Formatter «Excel addin«, Bob Phillips
    & Frank Kabel, addin that makes it possible to enter up to 50 conditions
    with the same entry type panels as builtin Conditional Formatting.
    Note this is Beta software (testing not production). (posted 2004-11-07)
    http://www.xldynamic.com/source/xld.....Download.html

    ---
    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

    "eric beck" <eric beck@discussions.microsoft.com> wrote in message news:64C22264-EFC5-4526-874D-81189914264B@microsoft.com...
    > I know that Excel 2000 will only allow you to have 3 Conditions for
    > Conditional Formatting, is there any way to get more?
    >
    > Not sure how many more will be needed but 3 isn't enough...
    >
    > could you notify me to this address: eric_beck05@hotmail.com
    >
    > Thanks




  4. #4
    David McRitchie
    Guest

    Re: Additional Conditions for Conditional Formatting

    Hi Eric,
    One way is to use a Change Event macro (not for formulas)
    http://www.mvps.org/dmcritchie/excel/event.htm#case

    The other way is t use an Addon that extends the number of conditions
    Extended Conditional Formatter «Excel addin«, Bob Phillips
    & Frank Kabel, addin that makes it possible to enter up to 50 conditions
    with the same entry type panels as builtin Conditional Formatting.
    Note this is Beta software (testing not production). (posted 2004-11-07)
    http://www.xldynamic.com/source/xld.....Download.html

    ---
    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

    "eric beck" <eric beck@discussions.microsoft.com> wrote in message news:64C22264-EFC5-4526-874D-81189914264B@microsoft.com...
    > I know that Excel 2000 will only allow you to have 3 Conditions for
    > Conditional Formatting, is there any way to get more?
    >
    > Not sure how many more will be needed but 3 isn't enough...
    >
    > could you notify me to this address: eric_beck05@hotmail.com
    >
    > Thanks




  5. #5
    eric beck
    Guest

    Additional Conditions for Conditional Formatting

    I know that Excel 2000 will only allow you to have 3 Conditions for
    Conditional Formatting, is there any way to get more?

    Not sure how many more will be needed but 3 isn't enough...

    could you notify me to this address: eric_beck05@hotmail.com

    Thanks

  6. #6
    David McRitchie
    Guest

    Re: Additional Conditions for Conditional Formatting

    Hi Eric,
    One way is to use a Change Event macro (not for formulas)
    http://www.mvps.org/dmcritchie/excel/event.htm#case

    The other way is t use an Addon that extends the number of conditions
    Extended Conditional Formatter «Excel addin«, Bob Phillips
    & Frank Kabel, addin that makes it possible to enter up to 50 conditions
    with the same entry type panels as builtin Conditional Formatting.
    Note this is Beta software (testing not production). (posted 2004-11-07)
    http://www.xldynamic.com/source/xld.....Download.html

    ---
    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

    "eric beck" <eric beck@discussions.microsoft.com> wrote in message news:64C22264-EFC5-4526-874D-81189914264B@microsoft.com...
    > I know that Excel 2000 will only allow you to have 3 Conditions for
    > Conditional Formatting, is there any way to get more?
    >
    > Not sure how many more will be needed but 3 isn't enough...
    >
    > could you notify me to this address: eric_beck05@hotmail.com
    >
    > Thanks




+ 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