+ 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
    10,991
    Thank Post
    851
    Thanked 2,653 Times in 2,253 Posts
    Blog Entries
    9
    Rep Power
    764
    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 02: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, 03:34 PM
  2. excel formula help again please
    By RabbieBurns in forum Windows
    Replies: 2
    Last Post: 13th August 2008, 05:31 PM
  3. Conditional formatting help needed
    By Jobos in forum How do you do....it?
    Replies: 3
    Last Post: 3rd June 2008, 01:58 PM
  4. Excel Formula Help
    By DSapseid in forum Windows
    Replies: 4
    Last Post: 7th November 2007, 04:56 PM
  5. Help with conditional formatting
    By randle in forum Windows
    Replies: 3
    Last Post: 25th October 2007, 01: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
  •