+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, Excel - Conditional Formatting using formula in Technical; Hello, Is there a formula to use in conditional formatting that would do the following. If 'B1' is between 0.01% ...
  1. #1

    Join Date
    Nov 2006
    Location
    Lancashire
    Posts
    95
    Thank Post
    34
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Excel - Conditional Formatting using formula

    Hello,

    Is there a formula to use in conditional formatting that would do the following.

    If 'B1' is between 0.01% and 20% the value of 'A1' = condition 1

    ELSE IF 'B1' is between 20.01% and 75% the value of 'A1' = condition 2

    ELSE IF 'B1' is over 75% the value of 'A1' = condition 3

    Thanks,

    Ben

  2. #2

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,271
    Thank Post
    884
    Thanked 2,749 Times in 2,322 Posts
    Blog Entries
    11
    Rep Power
    785
    Not exactly what you asked for but the logic pattern for this problem is:
    Code:
    =IF(AND((B1<(0.2*A1)),(B1>(0.01*A1))),"Condition 1",IF(AND((B1>(0.2*A1)),(B1<(0.75*A1))),"condition 2",IF((B1>(0.75*A1)),"condition 3","no")))
    using built in cell formulas, not sure if you can do it in 2k3 with conditional formatting as I am on 2k7 here. You can do it by formula in 2k7 which would require you to break it up into each stage and make a rule for each individual set of conditions

    Edit: Never mind my convoluded answer, here is a tutorial:
    http://blogs.techrepublic.com.com/msoffice/?p=831
    Last edited by SYNACK; 10th June 2009 at 03:29 PM.

  3. Thanks to SYNACK from:

    park_bench (10th June 2009)



SHARE:
+ Post New Thread

Similar Threads

  1. Excel Formula
    By denon101 in forum How do you do....it?
    Replies: 3
    Last Post: 1st December 2008, 04:34 PM
  2. excel formula help again please
    By RabbieBurns in forum Windows
    Replies: 2
    Last Post: 13th August 2008, 06:31 PM
  3. Conditional formatting help needed
    By Jobos in forum How do you do....it?
    Replies: 3
    Last Post: 3rd June 2008, 02:58 PM
  4. Excel Formula Help
    By DSapseid in forum Windows
    Replies: 4
    Last Post: 7th November 2007, 05:56 PM
  5. Help with conditional formatting
    By randle in forum Windows
    Replies: 3
    Last Post: 25th October 2007, 02:20 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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